[已解决]数值靠档换算成对应的ABC

jf530qy · 发表于 2016-12-5 17:51

求高手帮忙，谢谢。。。。。。。

最佳答案

望帝春心

2016-12-5 18:00

=LOOKUP("々",IF({1,0},"-",LOOKUP(C8,{0,"E";60,"D";65,"C";70,"B-";75,"B-";80,"B+";85,"A-";90,"A";95,"A+"})))

复制代码

望帝春心 · 发表于 2016-12-5 18:00

=LOOKUP("々",IF({1,0},"-",LOOKUP(C8,{0,"E";60,"D";65,"C";70,"B-";75,"B-";80,"B+";85,"A-";90,"A";95,"A+"})))

复制代码

望帝春心 · 发表于 2016-12-5 18:00

复制代码

苏子龙 · 发表于 2016-12-6 08:27

用辅助区域+index,match

		自动登录	找回密码
密码			注册

[已解决]数值靠档 换算成对应的ABC