Income tax excel formula for ay 2017-2018 and ay 2018-2019

Ankush Ghildiyal (Article) (49 Points)

01 March 2018  

Here Is Excel Formula For Tax Calculation For The Year AY 2017-2018 and AY 2018-2019 

=IF(I182<250000,0,IF(I182<500000,(I182-250000)*5%,IF(I182<1000000,(I182-500000)*20%+12500,IF(I182>1000000,(I182-1000000)*3%+112500,))))