我现在有如下公式,目前还想实现如果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
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/02 20:05:51
![我现在有如下公式,目前还想实现如果G列等于“标”,“协A”,“协B”,“成交”等的话就为空白,超层数了=IF(D6=](/uploads/image/z/10398088-64-8.jpg?t=%E6%88%91%E7%8E%B0%E5%9C%A8%E6%9C%89%E5%A6%82%E4%B8%8B%E5%85%AC%E5%BC%8F%2C%E7%9B%AE%E5%89%8D%E8%BF%98%E6%83%B3%E5%AE%9E%E7%8E%B0%E5%A6%82%E6%9E%9CG%E5%88%97%E7%AD%89%E4%BA%8E%E2%80%9C%E6%A0%87%E2%80%9D%2C%E2%80%9C%E5%8D%8FA%E2%80%9D%2C%E2%80%9C%E5%8D%8FB%E2%80%9D%2C%E2%80%9C%E6%88%90%E4%BA%A4%E2%80%9D%E7%AD%89%E7%9A%84%E8%AF%9D%E5%B0%B1%E4%B8%BA%E7%A9%BA%E7%99%BD%2C%E8%B6%85%E5%B1%82%E6%95%B0%E4%BA%86%3DIF%28D6%3D%22%22%2C%22%22%2CIF%28OR%28G6%3D%22b%22%2CLEFT%28G6%2C1%29%3D%22y%22%2COR%28G6%3D%22g%22%2CLEFT%28G6%2C1%29%3D%22j%22%2CAND%28G6%3D%22%22%2CLEFT%28F6%2C1%29%3D%22Q%22%29%2CLEFT%28F6%2C1%29%3D%22%5B%22%29%29%2CIF%28G)
我现在有如下公式,目前还想实现如果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
我现在有如下公式,目前还想实现如果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楼的回复
我现在有如下公式,目前还想实现如果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
=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)="工","工字钢",""))))))