工资条(excel公式)

部门行政部行政部行政部行政部行政部行政部行政部行政部行政部行政部岗位人事专员人事专员司机司机厨师厨师厨工厨工清洁工清洁工姓名王一方方李全吴力施文明张方张千华施元明李元英吴单英入职时间2013-07-152013-07-222013-11-112014-08-082012-10-212014-04-012014-06-162014-09-092014-10-292014-09-19工资额度基本工资30003200450050003000300022002200200020001500170020002200150015001500150015001500绩效工资150015002500280015001500700700500500绩效分数100100100100100100100100100100补贴其他计薪天数应发合计25.0025.0025.0025.0025.0025.0025.0025.0025.0025.003000.003200.004500.005000.003000.003000.002200.002200.002000.002000.00社保120.00120.00120.00120.00120.00120.00120.00120.00120.00120.00失业15.0015.0015.0015.0015.0015.0015.0015.0015.0015.00医保62.2262.2262.2262.2262.2262.2262.2262.2262.2262.22公积金个税0.000.0024.0839.080.000.000.000.000.000.00税后扣除19.3419.3419.3419.34代扣合计实发工资备注197.222802.78216.562983.44221.304278.70255.644744.36216.562783.44216.562783.44197.222002.78197.222002.78197.221802.78197.221802.78个税

00

24.083439.0834

000000

保留2位小数

0024.0839.08

000000