发个公式你自己替换一下S2为你自己的单元格,然后复制该公式。
计算工资的公式:
=IF(S2<=1500,S2*3%,IF(S2<=4500,S2*10%-105,IF(S2<=9000,S2*20%-555,IF(S2<=35000,S2*25%-1005,IF(S2<=55000,S2*30%-2755,IF(S2<=80000,S2*35%-5505,S2*45%-13506))))))
计算年终一次性奖金的公式:
=IF(S2/12<=1500,S2*3%,IF(S2/12<=4500,S2*10%-105,IF(S2/12<=9000,S2*20%-555,IF(S2/12<=35000,S2*25%-1005,IF(S2/12<=55000,S2*30%-2755,IF(S2/12<=80000,S2*35%-5505,S2*45%-13506))))))
联系客服