让我举个例子,如果您要计算单元格C1中A1的新个人所得税,则公式如下:
C1 =圆(MAX((A1-3500)* 5%* {0.6,2,4,5,6,7,9} -5 * {0,21,111,201,551,1101,2701},0),2)