关于这个EXCEL个税公式的原理答:1、第一步:(A2-3500)=50(应付工资的扣除余额减去个税起征点3500);2、(A2-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}={1.5,5,10,12.5,15,17.5,22.5}(应纳税额乘以7个等级税率);3、在工作表B2输入公式:=ROUND(MAX((A2-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,...
求Excel高手教怎样设置个税Excel计算公式答:工资个税计算方法:我的税前工资写在B25单元格,先在另外的地方列出个税层级,见下图:然后用以下公式即可:=IF(B25-H3>H9,(B25-H3)*I9-J9,IF(B25-H3>H8,(B25-H3)*I8-J8,IF(B25-H3>H7,(B25-H3)*I7-J7,IF(B25-H3>H6,(B25-H3)*I6-J6,IF(B25-H3>H5,(B25-H3)*I5-J5,IF(B25-H3...
请问怎样理解个人所得税EXCEL计算公式答:要理解这个公式首先要明白个人所得税的计算方法。在编辑栏里或者双击单元格,用鼠标选中0.05*{1,2,3,4,5,6,7,8,9},按F9,看看是什么?{0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}是不是各级税率?再选中25*{0,1,5,15,55,135,255,415,615},按F9,{0,25,125,375,...