W2=ROUND(MAX((V2-2000)*{5,10,15,20,25,30,35,40,45}%-{0,25,12

来源：学生作业帮编辑：作业帮分类：数学作业时间：2024/05/07 05:17:12

W2=ROUND(MAX((V2-2000)*{5,10,15,20,25,30,35,40,45}%-{0,25,125,375,1735,3375,6375,10375,15375}),2)
请问这个公式该怎么理解呀?怎么知道对应的税率及对应的扣除数呀?

可利用“公式审核/求值”查看计算过程,帮助理解公式.
公式中2000为起征额,第一组数据为各档税率,第二组数据为速算扣除数,将应交税工资额与各档税率分别相乘,再分别送去相应的扣除数后,取结果中的最大值即为应交税额.
另外,这个公式有小错误,即V2小于2000时,结果为负数.
建议改为：
=ROUND(MAX(((V2-2000)*{5,10,15,20,25,30,35,40,45}%-{0,25,125,375,1735,3375,6375,10375,15375}),),2)
还可简化一下：
=ROUND(MAX((V2-2000)*{1,2,3,4,5,6,7,8,9}*5%-25*{0,1,5,15,55,135,255,415,615},),2)
还有两个更精简的个税计算公式：
=SUM(5*TEXT(V2%-20-5*{0,1,4,10,40,80,120,160,200},"[

W2=ROUND(MAX((V2-2000)*{5,10,15,20,25,30,35,40,45}%-{0,25,12 EXCEL计税函数：=ROUND(MAX((W6-3500)*{3,10,20,25,30,35,45}%-{0,105 如何变更 =ROUND(MAX((Y19-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1, =ROUND(MAX((B2-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,5 计税公式ROUND(MAX((V3-2000)*5%*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15, =ROUND((B3-MAX(B5-B4,0))*LOOKUP(B3/12,{0,500,2000,5000,20000 变更ROUND(MAX(Y3-4800)*0.05*{1,2,3,4,5,6,7,8,9}-25*0,1,5,15,55 =ROUND(MAX(IF(S7-2000>{0,500,2000,5000,20000,40000,60000,800 =ROUND(MAX((A1-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111,201, round 函数ROUND(MAX(((I4-SUM(K4:O4))-2000)*0.05*{1,2,3,4,5,6,7 EXCEL中的这个公式是什么意思?=ROUND(MAX(F11/1000,E11)*D23*$F$10,2) =round((10^rand()*5),0