如何在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,"合格","差")))
Excel中IF函数的嵌套用法 求等于0为A, 0~5位为B,6-10为C,10以上为D...答:公式:=IF(A1>10,"D",IF(A1>5,"C",IF(A1>0,"B","A")))或者:=IF(A1<1,"A",IF(A1<6,"B",IF(A1<11,"C","D")))如果不是一定要用IF函数的,用以下公式可精简一些:=LOOKUP(A1,{0,"A";1,"B";6,"C";11,"D"})