原因:在使用了ROUND函数之后就不需要添加IF函数,否则会导致计算错误,可以使用MAX函数代替。
解决方法(以excel2016为例):
1、首先在输入错误的计算公式位置将原本的公式删除,点击到B1单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f636afc379310a55dc5e960ab94543a9832610d1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后在单元格内输入公式:= ROUND(MAX((A1-5000)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3fb43166d224f4a8eab3bed07f790529822d11a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击回车即可得到根据A1单元格数据而计算出的个税金额,可以看到低于5千元的收入是不缴税的。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/aa64034f78f0f736c3f804ff0455b319eac413cd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击公式单元格并下拉公式即可批量填充计算个税的结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/14ce36d3d539b600eaf44749e750352ac65cb712?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)