EXCEL多个if、or、and函数嵌套,但是报错了,哪里有问题?答:=IF(OR(A5=1,A5=5),"1",IF(A5=3,"需人工添加",IF(OR(I5="暂无评分",J5="暂无评论"),"暂时无法确定系数",IF(I5<=9.2,"0",IF(I5<=9.5,"0.5",IF(I5<9.8,"1",IF(J5<1000,"1",IF(J5<2000,"1.5","2")))当A5=1或者5时,值为1 当A5等于3时,值为“需人工添加...
为什么多条件if函数嵌套结果错误?答:excel里没有104.2>=C3>100这种写法,这个要写做AND(C3>=100,C3<=104.2),后面是一样的,另外,区域判断一般用lookup,你上面的公式可以是 =lookup(c3,{0,88,92.5,100.3,104.2},{"下","中下","中等","中上","上"})
如何在if函数中嵌套if函数答:IF(D4>=90,"优",IF(D4>=80,"良",IF(D4>=70,"中",IF(D4>=60,"合格",IF(D4<60,"差"))),或=(IF(D4=90,"优",IF(D4>=80,"良",IF(D4>=70,"中",IF(D4>=60,"合格","差")))