Question

在excel上做题，用IF圈套函数做一个工资表计算个人所得税，A1工资B1计算

在excel上做题，用IF圈套函数做一个工资表计算个人所得税，A1工资B1计算得税，以excel文件夹保存！！！谁能做，快快谢谢

Answer 1

=IF(A1<=5000,A1*0.03-105,IF(A1<=4500,A1*0.1-455,IF(A1<=9000,A1*0.2-1255,IF(A1<=35000,A1*0.25-1880,IF(A1<=55000,A1*0.3-3805,IF(A1<=80000,A1*0.35-6730,A1*0.45-15080))))))

Answer 2

A1为总工资，个税在B1，公式为
=ROUND(MAX((A1-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0),2)