excel根据分数判断优良中差

H3 单元格是分数,I3 单元格显示 优良中差,那么在 I3单元格写下面语句:

=IF(H3>=90,"优",IF(H3>=80,"良",IF(H3>=70,"中","差")))

原文出处:https://malaoshi.top/show_1IX5rNj1F9FP.html