excel如何设置计算税率
方法/步骤
1、1.打开excel
2、2.输入工号,姓名,部门,应发工资,应交税所得额,税率
3、3.把鼠钿泼兽匿标定在f2中,输入=IF(E2<=3000,0.03,IF(E2<=12000,0.1,IF(E2<=25000,0.2,IF(E2<=3500扉钛笆哇0,0.25,IF(E2<=5500,0.3,IF(E2<=80000,0.35,0.45))))))
4、4.按住enter键,最后税率就设置出来了
excel如何设置计算税率
方法/步骤
1、1.打开excel
2、2.输入工号,姓名,部门,应发工资,应交税所得额,税率
3、3.把鼠钿泼兽匿标定在f2中,输入=IF(E2<=3000,0.03,IF(E2<=12000,0.1,IF(E2<=25000,0.2,IF(E2<=3500扉钛笆哇0,0.25,IF(E2<=5500,0.3,IF(E2<=80000,0.35,0.45))))))
4、4.按住enter键,最后税率就设置出来了