Others
1212 Points
Joined July 2015
type in cell say d16
=IF(D15>=1000000,(D15-1000000)*0.3+125000,IF(D15>500000,(D15-500000)*0.2+25000,IF(D15>=250000,(D15-250000)*0.1-MIN((D15-250000)*0.1,2000),0)))
let D15 contain the taxable income
87A is taken care off here
I hope this helps and this is what you want.
Happy tax calculating