87a rebate excel formula for ay 2020-21

shubham singh (Job) (41 Points)

15 April 2019  

If Total Income is less than equal to 500000 then Rebate under 87A will be 12500

Here is the Excel Formula.

Lets say Total Income Cell is A4 and tax cell is A5.

formula,   =if A4<=500000,MIN(A5,12500),0)

thankyou