个所税

pureshadow

IF只能套七层,像这样IF里还有ROUND,套的层数更少.
贴个通用的:
=ROUND(MAX((L16-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0),2)
反推税前的:
=MIN((M17+25*{0,1,5,15,55,135,255,415,615})/(0.05*{1,2,3,4,5,6,7,8,9})+2000)

pureshadow

图中是内存数组每个计算的过程,最后取最大值,即橙色的值.