第2个回答 2013-05-28
假设分数在F3,在G3中输入或复制粘贴下列公式之一
=IF(F3>90,"优",IF(F3>75,"良",IF(F3>=60,"合格","补考")))
=IF(F3<60,"补考",IF(F3<=74,"合格",IF(F3<=89,"良","优")))
=IF(F3="","",LOOKUP(F3,{0,60,75,90},{"补考","合格","良","优"}))
下拉填充本回答被提问者和网友采纳
第3个回答 2013-05-28
C3为考试成绩的话,H3单元格公式:
=lookup(c3,{0,60,75,90},{"补考","合格","良","优"})
第4个回答 2013-05-28
用IF 函数多层钳套 =IF(F3<60,"不及格",IF(F3<=74,"合格",IF(F3<=89,"良","优")))