excel中如何输入公式

Question

=if（c4≤35，d4=优，if（36≤c4≤75，d4=良，if（76≤c4≤115，d4=轻度污染，if（116≤c4≤119，d4=中度污染，if（115≤c4≤250，d4=重度污染，if（c4>250，d4=严重污染）））））） 哪个地方错了

Answer 1

D4输入=if(c4<=35,“优”，if(c4<=75,"良",if(C4<=115,"轻度污染",if(c4<=119,"中度污染",if(c4<=250,"重度污染","严重污染")))))
或 D4输入=IF(C4>250,"严重污染",IF(C4>119,"重度污染",IF(C4>115,"中度污染",IF(C4>75,"轻度污染",IF(C4>35,"良","优")))))

Answer 2

在D4中输入公式
=lookup(c4,{0,36,76,116,120,251},{"优","良","轻度污染","中度污染","重度污染","严重污染"}
还想说一下你里面的应该是120≤c4≤250属于重度污染，而不是你公式里面的115≤c4≤250
如果确实想用你好公式可在D4中输入
=if（c4<=35，"优"，if（c4<=75，"良"，if（c4<=115，d4=轻度污染，if（c4<=119，"中度污染"，if（c4<=250，"重度污染"，"严重污染"）））））

Answer 3

D4输入或粘贴如下公式之一：
=IF(C4="","",IF(C4<=35,"优",IF(C4<=75,"良",IF(C4<=115,"轻度污染",IF(C4<=119,"中度污染",IF(C4<=250,"重度污染","严重污染"))))))

或者：
=IF(C4="","",LOOKUP(C4,{0,35,75,115,119,250},{"优","良","轻度污染","中度污染","重度污染","严重污染"}))

Answer 4

这个公式错了

36≤c4≤75， 应该是

c4>=36 and c4<=75, 其他类似的都有这个错误。本回答被提问者采纳

Answer 5