多条件多结果怎么使用函数?用if吗?

多条件多结果怎么使用函数?用if吗?如图,怎么实现?
2025-06-28 07:22:04
推荐回答(1个)
回答1:

=IF(B2<40,"太差了",IF(B2<50,"较差",IF(B2<60,"差",IF(B2<70,"优良",IF(B2<80,"优秀",IF(B2<90,"奖学金","年度奖学金"))))))