if函数多怎么多条件多结果。

2025-03-23 09:41:09
推荐回答(2个)
回答1:

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

回答2:

使用switch() case分枝实现