=ROUND(MAX((T5-3500)*5%*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,110...答:1.第一层函数:round(X,2)是一个四舍五入到小数点后两位的函数,2.第二层函数:MAX((a1-3500)*5%*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),计算的数值是(a2-3500)后的值与相应税级百分数(0,0.03,0.1,0.2……)的乘积减去税率所在级距的速算扣除数0...
=ROUND(MAX((a1-3500)*5%*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,110...答:1.第一层函数:round(X,2)是一个四舍五入到小数点后两位的函数,2.第二层函数:MAX((a1-3500)*5%*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),计算的数值是(a2-3500)后的值与相应税级百分数(0,0.03,0.1,0.2……)的乘积减去税率所在级距的速算扣除数0...