文件名称：Excel常用公式及时分享
文件大小：11KB
文件格式：DOCX
更新时间：2022-04-02 02:27:32
文件
工作中经常会用到相关的公式，=IF(MID(J2,9,2)="01","营业部",IF(MID(J2,9,2)="02","林州营销部",IF(MID(J2,9,2)="03","内黄支公司",IF(MID(J2,9,2)="04","滑县支公司",IF(MID(J2,9,2)="05","铁西营销部",IF(MID(J2,9,2)="06","文昌营销部",IF(MID(J2,9,2)="07","汤阴营销部",IF(MID(J2,9,2)="08","水冶营销部",IF(MID(J2,9,2)="10","车商渠道部",IF(MID(J2,9,2)="14","安东支公司",""))))))))))