这个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
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 11:09:57
![这个EXL公式怎么弄?=IF(OR(B2=00,B2=01,B2=02,B2=03,B2=04,B2=95,B2=96,B2=97,B2=98,B2=99),](/uploads/image/z/6602723-35-3.jpg?t=%E8%BF%99%E4%B8%AAEXL%E5%85%AC%E5%BC%8F%E6%80%8E%E4%B9%88%E5%BC%84%3F%3DIF%28OR%28B2%3D00%2CB2%3D01%2CB2%3D02%2CB2%3D03%2CB2%3D04%2CB2%3D95%2CB2%3D96%2CB2%3D97%2CB2%3D98%2CB2%3D99%29%2C%22A%22%2CIF%28OR%28B2%3D05%2CB2%3D06%2CB2%3D07%2CB2%3D08%2CB2%3D09%2CB2%3D90%2CB2%3D91%2CB2%3D92%2CB2%3D93%2CB2%3D94%29%2C%22B%22%2CIF%28OR%28B2%3D10%2CB2%3D11%2CB2%3D12%2CB2%3D13%2CB2%3D14%2CB2%3D85%2CB2%3D86%2CB2%3D87%2CB2%3D88%2CB2%3D89%29%2C%22C%22%2CIF%28OR%28B2%3D15)
这个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")
三个公式都可以
不是已经全了吗?可以了啊:)