excel函数 DB SLN是什么的简写?-ZOL问答

8个回答默认排序

默认排序

按时间排序

没找到满意答案？去问秘塔AI搜索

取消复制问题

joanne512

已采纳

Excel360里，DB是余额递减法，SLN是直线法～

取消评论

精品应用推荐

超值推荐

antiares

=COUNTIF(A16:F16,A2)=1

取消评论

267876120

公式如下：
=TEXT(WEEKDAY(A1,1),"ddd")

取消评论

a250979655

D2输入
=LOOKUP(CODE(C2),45217+{0,36,544,1101,1609,1793,2080,25滑提著快严品体60,2902,3845,4107,4679,5154,5397,5405,5689,6170,62齐见九刘路29,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})&IF(LEN(C2)1,LOOKUP(CODE(MID(C2,2,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),"")&IF(LEN(C2)2,LOOKUP(CODE(MID(C2,3,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),"")

车并向

填充

取消评论

459634097

=IFERROR(MATCH(A2,A16:F16)=A2,1)

取消评论

starcraftI

D2输入
=LOOKUP(CODE(C2),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,46课精介告均课善79,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})&IF(LEN(C2)1,LOOKUP(CODE(MID(C2,2,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C360问答","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),"")&IF(LEN(C必再利读还差2)2,LOOKUP(CODE(MID(C2,3,1)),45217+{0,36,544,1101,1609,1793,2080,2支还器560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,矿玉7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),"")