这个EXL公式怎么弄?=IF(OR(B2=00,B2=01,B2=02,B2=03,B2=04,B2=95,B2=96,B2=97,B2=98,B2=99),"A",IF(OR(B2=05,B2=06,B2=07,B2=08,B2=09,B2=90,B2=91,B2=92,B2=93,B2=94),"B",IF(OR(B2=10,B2=11,B2=12,B2=13,B2=14,B2=85,B2=86,B2=87,B2=88,B2=89),"C",IF(OR(B2=15

这个EXL公式怎么弄?=IF(OR(B2=00,B2=01,B2=02,B2=03,B2=04,B2=95,B2=96,B2=97,B2=98,B2=99),"A",IF(OR(B2=05,B2=06,B2=07,B2=08,B2=09,B2=90,B2=91,B2=92,B2=93,B2=94),"B",IF(OR(B2=10,B2=11,B2=12,B2=13,B2=14,B2=85,B2=86,B2=87,B2=88,B2=89),"C",IF(OR(B2=15
这个EXL公式怎么弄?
=IF(OR(B2=00,B2=01,B2=02,B2=03,B2=04,B2=95,B2=96,B2=97,B2=98,B2=99),"A",IF(OR(B2=05,B2=06,B2=07,B2=08,B2=09,B2=90,B2=91,B2=92,B2=93,B2=94),"B",IF(OR(B2=10,B2=11,B2=12,B2=13,B2=14,B2=85,B2=86,B2=87,B2=88,B2=89),"C",IF(OR(B2=15,B2=16,B2=17,B2=18,B2=19,B2=80,B2=81,B2=82,B2=83,B2=84),"D",IF(OR(B2=20,B2=21,B2=22,B2=23,B2=24,B2=75,B2=76,B2=77,B2=78,B2=79),"E",IF(OR(B2=25,B2=26,B2=27,B2=28,B2=29,B2=70,B2=71,B2=72,B2=73,B2=74),"F",IF(OR(B2=30,B2=31,B2=32,B2=33,B2=34,B2=65,B2=66,B2=67,B2=68,B2=69),"G",IF(OR(B2=35,B2=36,B2=37,B2=38,B2=39,B2=60,B2=61,B2=62,B2=63,B2=64),"H",IF(OR(B2=40,B2=41,B2=42,B2=43,B2=44,B2=55,B2=56,B2=57,B2=58,B2=59),"I","J")))))))))我知道以上公式级数太多,要怎么改可以减少级数?谢一个先!
EXL不行呀！我上网查过，超过七级EXL就有问题？公式要变换呀！

这个EXL公式怎么弄?=IF(OR(B2=00,B2=01,B2=02,B2=03,B2=04,B2=95,B2=96,B2=97,B2=98,B2=99),"A",IF(OR(B2=05,B2=06,B2=07,B2=08,B2=09,B2=90,B2=91,B2=92,B2=93,B2=94),"B",IF(OR(B2=10,B2=11,B2=12,B2=13,B2=14,B2=85,B2=86,B2=87,B2=88,B2=89),"C",IF(OR(B2=15
=LOOKUP(A1,{0,5,10,15,20,25,30,35,40,45,50,55,60,65,70,75,80,85,90,95;"A","B","C","D","E","F","G","H","I","J","J","I","H","G","F","E","D","C","B","A"})
=CHOOSE(INT(A1/5+1,"A","B","C","D","E","F","G","H","I","J","J","I","H","G","F","E","D","C","B","A")
=CHOOSE(IF(INT(A1/5)+1>10,20-INT(A1/5),INT(A1/5)+1),"A","B","C","D","E","F","G","H","I","J")
三个公式都可以

不是已经全了吗？可以了啊：）