excel个人所得税计算公式答:excel个人所得税计算公式为:(应发工资-个税起征点金额)*税率-速算扣除数 上面的excel个人所得税计算公式,思路讲解:(B2-3500)是个人所得税的应纳税所得额,{0.6,2,4,5,6,7,9}是一个数组。0.05*{0.6,2,4,5,6,7,9}={0.03,0.1,0.2,0.25,0.3,0.35,0.45} 是个人所得...
如何用excel计算应纳税所得额?答:55001-80000元,税率35 80000元以上,税率45 在D1单元格中输入公式:=IF(C1<=3000, C1*3%, IF(C1<=12000, C1*10%, IF(C1<=25000, C1*20%, IF(C1<=35000, C1*25%, IF(C1<=55000, C1*30%, IF(C1<=80000, C1*35%, C1*45%))),表示根据应纳税所得额的大小,分段计算个人所得...