if函数多个条件嵌套如A1≥2,就是25,A1≥4就是20,A1≥5,就是10怎么计算...答:if函数多个条件嵌套如A1≥2,就是25,A1≥4就是20,A1≥5,计算方法:=IF(A1>=2,25,IF(A1>=4,20,IF(A1>=5,18,16)))
如何在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,"合格","差")))