在EXCEL中,如果E9为1.2,则D9为优;如果E9为3.4.5,则D9为良,如果E9为6.7...
发布网友
发布时间：2024-10-24 14:59
共3个回答
热心网友
时间：2024-11-02 05:14
使用下列公式之一
=IF(OR(E9<1,E9>9),"",LOOKUP(E9,{1,3,6,9},{"优","良","合格","差"}))
=IF(OR(E9<1,E9>9),"",IF(E9=9,"差",IF(E9>=6,"合格",IF(E9>=3,"良","优"))))
=IF(OR(E9<1,E9>9),"",IF(E9=9,"差",IF(E9<3,"优",IF(E9<6,"良","合格"))))
热心网友
时间：2024-11-02 05:10
=IF(OR(E9<1,E9>9),"不在判定范围",IF(E9<=2,"优",IF(E9<=5,"良",IF(E9<=8,"及格","差"))))
热心网友
时间：2024-11-02 05:16
这么简单还要用excel辨别？是不是有点简单问题复杂化
