...70至80为中等,60至70为及格,60以下不及格,IF函数该怎么写...答:假设分数在C83,那么公式为:=IF(C83>=90,"优秀",IF(C83>=80,"良好",IF(C83>=70,"中等",IF(C83>=60,"及格","不及格")))IF最多可套七个公式!
Excel中的IF函数怎么用?例:E1到E32中,大于90的为优,小于90的为良答:如果只有这两种情况,就很简单=if(E1>90,"优","良")如果还要细分=if(e1>90,"优",if(e1>70,"良",if(e1>60,"及格","不及格")))