excel根据部门列填充部门编号列,财务部、采购部、工程部、营运部的...答:,"HS10",IF(B5="采购部","HS11",IF(B5="工程部","HS12",IF(B5="营运部","HS13","")))1、首先,建立一个Excel表格 2、建立IF函数,并输入=IF(B5="财务部","HS10",IF(B5="采购部","HS11",IF(B5="工程部","HS12",IF(B5="营运部","HS13","")))3、然后点击确定 ...
excel根据部门列填充部门编号列,财务部、采购部、工程部、营运部的...答:,"HS10",IF(B5="采购部","HS11",IF(B5="工程部","HS12",IF(B5="营运部","HS13","")))1、首先,建立一个Excel表格 2、建立IF函数,并输入=IF(B5="财务部","HS10",IF(B5="采购部","HS11",IF(B5="工程部","HS12",IF(B5="营运部","HS13","")))3、然后点击确定 ...