怎么才能简化我的这个公式呢?太长了.

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/21 10:33:18

怎么才能简化我的这个公式呢?太长了.
=IF(B2="A6HG30","E6",IF(B2="A6HG31","B2",IF(B2="A1HG30","D1",IF(B2="A1HG31","D1",IF(B2="A1MG31","D2",IF(B2="A6SG30","A3",IF(B2="A6SG31","A3",IF(B2="F1CG31","C1",IF(B2="F4CG31","B3",IF(B2="F8CG30","D3",IF(B2="S2HG31","C3",IF(B2="S2HG30","B3",IF(B2="S4HG31","B3",IF(B2="S4HG30","B3",IF(B2="S4HG40","B3",IF(B2="S8HG30","D4",IF(B2="S9HG31","B1",IF(B2="S9HG30","B1",IF(B2="S9HG40","D4",IF(B2="SF1870","B3",IF(B2="W1HG30","D4")))))))))))))))))))))
另个,我这个公式是输入在H2的,要怎么才能让B2没有输入信息或者信息不满足这里面的条件的情况下,让H2显示空白呢?.

你这个是IF嵌套,简化不了了,
在最后面加上
=IF(B2="A6HG30","E6",IF(B2="A6HG31","B2",IF(B2="A1HG30","D1",IF(B2="A1HG31","D1",IF(B2="A1MG31","D2",IF(B2="A6SG30","A3",IF(B2="A6SG31","A3",IF(B2="F1CG31","C1",IF(B2="F4CG31","B3",IF(B2="F8CG30","D3",IF(B2="S2HG31","C3",IF(B2="S2HG30","B3",IF(B2="S4HG31","B3",IF(B2="S4HG30","B3",IF(B2="S4HG40","B3",IF(B2="S8HG30","D4",IF(B2="S9HG31","B1",IF(B2="S9HG30","B1",IF(B2="S9HG40","D4",IF(B2="SF1870","B3",IF(B2="W1HG30","D4","")))))))))))))))))))))

EXCEL公式太长帮我简化一下吧为什么一些求功的物理题用到动能定理,我怎么才能知道什么时候用这个公式呢如何简化SUMIF公式谢谢!后面还要加内容显示公式太长不能再设置了我在excel表格里第一行用了公式函数,怎么才能让下面的表格都应用这个公式,从而避免我一一重新设置函数请大神帮我把这个EXCEL公式简化. 谁有办法帮我简化这个公式根号的简化根号8怎么变成2根号2?根号34怎么简化能跟我说QQ吗？根号8我是懂了，那根号25分之2呢？我的QQ是4719 这个公式怎么推导的呢方差计算简化公式是怎么求出来的 .. 我发现了一种很奇怪的昆虫,好多人都不知道它是什么,我怎么才能查出这个昆虫是什么呢? 我的水杯接了一次热水后打不开了,怎么才能打开呢? IF函数公式如何简化?下面的公式如何简化,