excel表格B16大于等于95 结果为字母"A"；小于95且大于等于90结果为B；小于90且大于等于70结果为C；求公式

Question

如题所述

Answer 1

=IF(B16>=95,"A",IF(B16>=90,"B","C"))
或：
=LOOKUP(B16,{70,90,95},{"C","B","A"})

Answer 2

=IF(B16>=95,"A",IF(B16>=90,"B",IF(B16>=70,"C","")))本回答被提问者采纳

Answer 3

IF(B16>=95,A,IF(B16>=90,B,C))追答

因为没有小于70的选项

所以值不应小于70，所以我这么写

ABC要带引号

亲，不懂再问哈~

Answer 4

=LOOKUP(B16,{70,90,95},{"C","B","A"})
不用if嵌套那么麻烦