Question

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

这个式子怎么化简的

Answer 1

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

Answer 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","")))))))))))))))))))))

Answer 3

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

追问

就是均不等于0请问怎么化

Answer 4

可以这样的，

Answer 5

可以的，，，，

追问

怎么化？