excel如何实现填数值后自动判断等级

2025-03-20 06:43:13
推荐回答(2个)
回答1:

b2输入公式:=if(c2>250,"严重污染",if(c2>200,"重度污染",if(c2>150,"中度污染",if(c2>100,"轻度污染",if(c2>51,"良","优")))))

回答2:

公式如下:

=LOOKUP(C2,{0,51,101,151,201,251},{"优","良","轻度","中度","重度","严重"})