Question

EXCEL表格中如何设置对应等级？

如图所示，根据I3“最终得分”数值 按红色框中评定等级要求 设置 自动匹配“等级”，求"I4“单元格中需要输入的内容

Answer 1

1. 使用模糊查表功能可以解决。

2. 公式如下所示：

=VLOOKUP(I3,{0,"C";70,"B";95,"A"},2)

Answer 2

在I4里输入=IF(I3>=95,"A",IF(I3<70,"C","B"))

Answer 3

=IF(I3>=95,"A",IF(I3>=70,"B","C"))

Answer 4

=LOOKUP(I3,{0,"C";70,"B";95,"A"})

或
=LOOKUP(I3,{0,70,95},{"C","B","A"})