excel中if函数使用
计算个人所得税,应纳税额小于36000元,按照3%提算;大于36000,小于144000,按照10%计算;大于144000,小于300000,按照20%计算。列的公式如下:
3%:=IF(BV4<=36000,BV4*0.03,IF(BV4>36000,36000*0.03))
10%:=IF(BV4<=36000,0,IF(36000<BV4<=144000,(BV4-36000)*0.1,IF(BV4>144000,(144000-36000)*0.1)))
20%:=IF(BV4<=144000,0,IF(144000<BV4<=300000,(BV4-144000)*0.2,IF(BV4>300000,(300000-144000)*0.2)))
你指的应该是分区间缴税的公式:公式如下:
=IF(BV4<=0,"",IF(BV4<=36000,BV4*0.03,IF(AND(BV4>36000,BV4<=144000),36000*0.03+(BV4-36000)*0.1,36000*0.03+(144000-36000)*0.1+(BV4-144000)*0.2)))
意识是
当额度为 小于36000的时候,比如30000的时候,税额为:30000*3%
当额度为 36000到144000时,比如70000的时候,税额为:30000*3%+(70000-36000)*10%
当额度大于144000的时候,比如200000的时候,税额为:30000*3%+(144000-36000)*10%+(200000-144000)*20%
网络上有很多这样的公式:
=ROUND(MAX((BV4-5000)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2)
改为统一的即可:
=BV4*IF(BV4<=36000,0.03,IF(BV4<=144000,0.1,IF(BV4<=300000,0.2)))
下一篇:这样的电脑配置能卖多少钱?
上一篇:VBA下标越界怎么解决