Excel常用公式及时分享

工作中经常会用到相关的公式,=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","安东支公司","")))))