这个式子怎么化简，可以这样化简吗

这个式子怎么化简的

2025-05-14 18:00:12

推荐回答（5个）

回答1：

不可以，正确的化简方式是

回答2：

你这个是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","")))))))))))))))))))))

回答3：

当x和y均不等于0时，才可以这样化简

回答4：

可以这样的，

回答5：

可以的，，，，