...EXCEL的MAX函数在税金计算方面的应用怎么理解?!!答:比如应税金额为6000 =MAX(6000*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0)0.05*{1,2,3,4,5,6,7,8,9}相当于各档税率{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}相当于各档速算扣除数{0...
Excel 怎么根据个人所得税额倒推出工资额答:Excel根据个人所得税额倒推出工资额是需要输入一定的公式的,公式为:MAX((F2-3500)*5%*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},)。相关公式如下:(1)如果个人当月工资、薪金所得高于(或等于)税法规定的费用减除标准的,税款计算公式为:应纳税额=个人当月取得全年一次性...
如果用IF函数计算出个人所得税答:假设A1单元格是要计算税金的工资数,B1单元格为税率,C1单元格为扣除数,D1单元格为应交税金税率的公式为:(IF(AND(A1>0,A1<=500),5%,IF(AND(A1>500,A1<=2000),10%,IF(AND(A1>2000,A1<=5000),15%,IF(AND(A1>5000,A1<=20000),20%,IF(AND(A1>20000,A1<=40000),25%。IF(AND(A1>...