满足两个单元格条件if怎么用?答:抓图最忌没有行列号!看我的,在K3输入 =IF(B3="常规工作",IF(J3="优",5,IF(J3="良",3,0)),IF(J3="优",8,IF(J3="良",5,0)))回车并向下填充。
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,"...