谁能把我这个excel的三个公式合并在一起

来源：百度知道 编辑：UC知道 时间：2024/06/10 12:25:56
1、 =IF(LEFT(C4,1)<>"J",IF(OR(F4="东大沽",F4="星火",F4="曹庄",F4="百子湾",F4="陈塘庄",F4="八里庄",F4="塘沽",F4="燕郊",F4="王瞳",F4="李七庄",F4="张贵庄",F4="静海",F4="汉沽",F4="河间西",F4="霸州"),"王佐",""),"")
2、 =IF(C4="","",IF(LEFT(C4,1)<>"s",IF(OR(F4="东大沽",F4="神港"),"黄万",""),""))
3、 =IF(OR(F4="西柏坡",F4="灵寿",F4="行唐",F4="新曲",F4="定州西",F4="安国",F4="蠡县",F4="肃宁北",F4="河间",F4="沧州西",F4="李天木",F4="郭庄子"),"沿线","")

=IF(LEFT(C4,1)<>"J",IF(OR(F4="东大沽",F4="星火",F4="曹庄",F4="百子湾",F4="陈塘庄",F4="八里庄",F4="塘沽",F4="燕郊",F4="王瞳",F4="李七庄",F4="张贵庄",F4="静海",F4="汉沽",F4="河间西",F4="霸州"),"王佐",""),IF(C4="","",IF(LEFT(C4,1)<>"s",IF(OR(F4="东大沽",F4="神港"),"黄万",IF(OR(F4="西柏坡",F4="灵寿",F4="行唐",F4="新曲",F4="定州西",F4="安国",F4="蠡县",F4="肃宁北",F4="河间",F4="沧州西",F4="李天木",F4="郭庄子"),"沿线","")))))

对,用楼上那朋友的办法,你直接点=然后就输入你要的刚才那些东西放在一起就行了中间每个最前面的你要是加减乘除的符号就行

可以这样
=IF(LEFT(C4,1)<>"J",IF(OR(F4={"东大沽","星火","曹庄","百子湾","陈塘庄","八里庄","塘沽","燕郊","王瞳&