我现在有如下公式,目前还想实现如果G列等于“标”,“协A”,“协B”,“成交”等的话就为空白,超层数了=IF(D6="","",IF(OR(G6="b",LEFT(G6,1)="y",OR(G6="g",LEFT(G6,1)="j",AND(G6="",LEFT(F6,1)="Q"),LEFT(F6,1)="[")),IF(G

Question

我现在有如下公式,目前还想实现如果G列等于“标”,“协A”,“协B”,“成交”等的话就为空白,超层数了
=IF(D6="","",IF(OR(G6="b",LEFT(G6,1)="y",OR(G6="g",LEFT(G6,1)="j",AND(G6="",LEFT(F6,1)="Q"),LEFT(F6,1)="[")),IF(G6="b","扁钢",IF(LEFT(G6,1)="y","圆钢",IF(OR(G6="g",LEFT(G6,1)="j"),"钢板",IF(AND(G6="",LEFT(F6,1)="Q"),"轨道",IF(LEFT(F6,1)="[","槽钢"))))),IF(LEFT(F6,1)="δ","钢板",IF(LEFT(F6,1)="φ","钢管",IF(LEFT(F6,1)="H","H型钢",IF(OR(LEFT(F6,1)="L",LEFT(F6,1)="B"),"角钢",IF(LEFT(F6,1)="工","工字钢","")))))))
刚才又发现少了几个条件，还有方钢，方钢管，矩形管，矩形钢等没有加进去，不知道还能不能实现（或者剩余的直接可以等于D列），非常感谢2楼的回复

Answer 1

=IF(OR(D6="",G6={"标","协A","协B","成交"}),"",IF(G6="b","扁钢",IF(LEFT(G6)="y","圆钢",IF(OR(G6="g",LEFT(G6)="j"),"钢板",IF(AND(G6="",LEFT(F6)="Q"),"轨道",IF(LEFT(F6,1)="[","槽钢","")))))&IF(LEFT(F6)="δ","钢板",IF(LEFT(F6)="φ","钢管",IF(LEFT(F6)="H","H型钢",IF(OR(LEFT(F6)="L",LEFT(F6)="B"),"角钢",IF(LEFT(F6)="工","工字钢",""))))))