最实用：exce计算工资奖金保险

基本工资表基本工资表编号姓名所属部门职工类型基本工资部门奖金房补计算101刘艳办公部主管3500.00500350102周晓晓办公部员工2500.00500250103崔涛办公部员工2500.00500250201李蓓蕾人事部主管3000.00500450202田刚人事部员工2500.00500375301苏雪妍财务部主管3000.00500600302金欣财务部员工2500.00500500303王凤财务部员工2500.00500500401李岩采购部主管2500.00800375402何力采购部员工2000.00800300403宋宏伟采购部员工2000.00800300501陆鸿伟销售部主管2500.001000500502王锋销售部员工2000.001000400503汪峰销售部员工2000.001000400504李艳战略部员工2000.00ERROR:#N/A保险计算员工保险计算编号姓名所属部门职工类型基本工资养老保险医疗保险工伤保险公积金社保总计101刘艳办公部主管350028070352456301333102周晓晓办公部员工25002005025175450244103崔涛办公部员工25002005025175450201李蓓蕾人事部主管30002406030210540202田刚人事部员工25002005025175450301苏雪妍财务部主管30002406030210540302金欣财务部员工25002005025175450303王凤财务部员工25002005025175450401李岩采购部主管25002005025175450402何力采购部员工2000160402014036