if函数计算数据套嵌超过7个怎么办？

来源：百度知道 编辑：UC知道 时间：2024/06/10 02:29:30
数据设为a，有20个条件，结果为和a相关的不同等式的20个数据，都是数字格式。
我用if格式，超过7层不行，用&if追加也不行，用lookup那些更不行，
请高手帮忙。
我的公式如下：
＝IF(F32<22,F32*36*G32*0.97*0.982*60*E32/100000000,(IF(F23=22,F32*37*G32*0.97*0.982*60*E32/100000000,(IF(F32=23,F32*38*G32*0.97*0.982*60*E32/100000000,(IF(F32=24,F32*38*G32*0.97*0.982*60*E32/100000000,(IF(F32=28,F32*37.5*G32*0.97*0.982*60*E32/100000000,(IF(F32=29,F32*36*G32*0.97*0.982*60*E32/100000000,(IF(F32=30,F32*35*G32*0.97*0.982*60*E32/100000000,(IF(F32=31,1.5*E32*G32/2400,F32*38.5*G32*0.97*0.982*60*E32/100000000)))))))))))))))
还有很多条件没办法了。

可以用&来连接两个if()函数
例：
A1格 1～26
B1格对应为A~Z
函数如下
=IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",IF(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H",""))))))))&IF(A1=9,"I",IF(A1=10,"J",IF(A1=11,"K",IF(A1=12,"L",IF(A1=13,"M",IF(A1=14,"N",IF(A1=15,"O",IF(A1=16,"P",""))))))))&IF(A1=17,"Q",IF(A1=18,"R",IF(A1=19,"S",IF(A1=20,"T",IF(A1=21,"U",IF(A1=22,"V",IF(A1=23,"W",IF(A1=24,"X",""))))))))&IF(A1=25,"Y",IF(A1=26,"Z",""))

一个单元格也可以实现！
=IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",IF(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H",""))))))))&IF(A1=9,"I",IF(A1=10,"J&q