EXCEL已知实发工资计算应发工资的公式答:1、先填列好每位员工的实发工资 2、在应发工资栏F4单元格内输入公式=ROUND(MAX((H4-3500-{0,105,555,1005,2755,5505,13505})/(1-{0.03,0.1,0.2,0.25,0.3,0.35,0.45})+3500,H4),2) 后回车 3、拖动F4单元格右下角的黑十字向下到最后一栏 4、在个税栏G4输入公式=F4-H4 计算...
怎样用excel给工资配钞,计算工资100元、50元、20元、10元、5元、1元...答:简单制作如下表:B1到G1公式如下,按照需求进行修改。B2:=IF(LEN(A2)>=3,LEFT(A2,LEN(A2)-2))C2:=IF(RIGHT(A2,2)>="50","1","0")D2:=IF(RIGHT(A2,2)<="50",INT(RIGHT(A2,2)/20),"0")E2:=INT((RIGHT(A2,2)-20*D2)/10)F2:=INT((RIGHT(A2,2)-20*D2)/10)...
EXCEL已知实发工资计算应发工资的公式答:1、先填列好每位员工的实发工资 2、在应发工资栏F4单元格内输入公式=ROUND(MAX((H4-3500-{0,105,555,1005,2755,5505,13505})/(1-{0.03,0.1,0.2,0.25,0.3,0.35,0.45})+3500,H4),2) 后回车 3、拖动F4单元格右下角的黑十字向下到最后一栏 4、在个税栏G4输入公式=F4-H4 计算...