IF(T5-SUM(U5:X5)<3500,MAX((((P5+MAX(T5-SUM(U5:X5),0)-3500)/12>{0,1500,4500,9000,35000,55000,80000})*{3,10,20,25,30,35,45}%)*(P5+MAX(T5-SUM(U5:X5),0)-3500)-{0,105,555,1005,2755,5505,13505}),MAX(((P5/12>{0,1500,4500,9000,35000,55000,80000})*{3,10,20,25,30,35,45}%)*P5-{0,105,555,1005,2755,5505,13505}))
我就是需要了解这个公式的缘由
不是个税
追答公式里面一定是看不懂
MAX(A,B,C,D,E,F,G)的数组应用?
可以用F9来查看计算值