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
Menu
87a rebate excel formula for ay 2020-21
Replies (11)
it's not 500000 but it's 350000
nice shubham
w.e.f 1 April 2019, The Limit Is 500000
I agree with Mr.Shubham Singh.
| Originally posted by : rama krishnan | ||
 |
it's not 500000 but it's 350000 |  |
hi, shubam,
if(A4<=500000,MIN(A5,12500),0)
if a4=600000, a5=505000, formulae is not showing any difference, showing "0"
pl correct accoding its values.
sorry , working
For 87A REBATE CALCULATION KINDLY CHECK THIS FORMULA =if (A4<=500000,A5,12500)
Thank you
FOR 87A REBATE THIS FORMULA IS MORE APPROPRIATE
=IF(A4<=500000,MIN(A5,12500),0)
Is the formula still the same?
Can you Pelase post Excel File once more
Recent Topics :
- Enquiry on FAST-DS system generated email
- Capital gain on sale of agriculture land
- Demand from TRACES
- FY 2025-26 ITC CLAIM DUE DATE
- 96084000 and 48202000 HSN code ka Tax Rate kya hai
- Clarifications for intra day transactions
- CA FINAL FR FINANCIAL INSTRUMENTS (Ind AS 109) Dou
- 70:30 GST rule for solar EPC: partial scope (struc
- TDS on Redevelopers hardship allowance received no
- Who will take FSSAI AND TRADE LICENSE: owner or te
Related Topics :
CAclubindia
