if函数计算数据套嵌超过7个怎么办?答:可以用&来连接两个if()函数 例:A1格 1~26 B1格对应为A~Z 函数如下 =IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",IF(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H","")))&IF(A1=9,"I",IF(A1=10,"J",IF(A1=11,"...
excel中if函数的多层嵌套答:亲,完全按照你文字描述写的,逻辑性对不对就没做判断了:=IF(AND(K1=0,L1=0),J1,IF(AND(H1>K1,K1>0,L1=0),K1-H1+I1,IF(AND(K1>H1,L1=0),K1+I1,IF(AND(I1>L1,L1>0,K1=0),L1-I1+K1,IF(AND(L1>I1,K1=0),L1+H1,IF(AND(K1>0,L1>0),K1+L1,"")))...
excel满足多条件时自动填充数值,如何根据黄色区域的方案来判断红色区域...答:1、这个用IF函数解决比较方便,用多个IF函数进行嵌套;2、用IF函数一定要理顺逻辑关系;一定要记住如用大于在前面,一定要大于最大的,如用小于在前面,一定要小于最小的。3、在应奖励金额列下输入公式=IF(A2>=300,IF(B2>=95%,2300,IF(B2>=90%,2150,IF(B2>=85%,2000,IF(B2>=80%,1850,IF...