我现在有如下公式,目前还想实现如果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/11 23:22:39
![我现在有如下公式,目前还想实现如果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)
xTQkP/A})-vP|r/RID躵KiͭIڎe[v- FMԿIfIFD0sE(稸7LP*Aճ֡}`|ΊTWK n=ɳ.*$!{>&]
50O