excel里个人所得税公式问题

发布网友发布时间：2023-10-23 19:56

共4个回答

热心网友时间：2024-11-26 20:07

=IF(MAX(ROUND((J7-P7-Q7-R7-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},2))<=0,"",MAX(ROUND((J7-P7-Q7-R7-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},2)))

热心网友时间：2024-11-26 20:07

=IF(MAX(ROUND((J7-P7-Q7-R7-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},2))<0,0,MAX(ROUND((J7-P7-Q7-R7-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},2)))

这是取巧的方法，容易理解

热心网友时间：2024-11-26 20:08

外边再加个MAX, 就是结果与0值比较，小于0的，取值为0.

=max(MAX(ROUND((J7-P7-Q7-R7-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},2)),0)

热心网友时间：2024-11-26 20:08

=if(J7-P7-Q7-R7-2000<=0,0,max(round((J7-P7-Q7-R7-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},2)))