Kumar@raja
Member
Dear Friends,
Kindly provide me the formula for the attached file which suits for column B4. Here, formula which I indicated was not bringing the correct number.
I need the result as follows:
Most of you know that from the F.Y:2013-14 onwards Income tax department introduced a tax rebate U/s 87A for an amount of Rs. 2 K or tax payable whichever is less if one total Income is below or equivalent to Rs. 5 Lakhs. In this connection in attached sheet if cell B1<= 500000, B4 should be 2000/-. However, if B1 is Rs. 2,10,000/- Tax payable in B3 will be reduced to an extent and the same comes below Rs. 2000/-. Here B4 should be equivalent to B3, as rebate is restricted up to Rs. 2000/- or equivalent amount of tax payable.
I hope you all catch my point, therefore please do the needful and provide me appropriate formula for B4.
Thanks in advance,
Kumar
Kindly provide me the formula for the attached file which suits for column B4. Here, formula which I indicated was not bringing the correct number.
I need the result as follows:
Most of you know that from the F.Y:2013-14 onwards Income tax department introduced a tax rebate U/s 87A for an amount of Rs. 2 K or tax payable whichever is less if one total Income is below or equivalent to Rs. 5 Lakhs. In this connection in attached sheet if cell B1<= 500000, B4 should be 2000/-. However, if B1 is Rs. 2,10,000/- Tax payable in B3 will be reduced to an extent and the same comes below Rs. 2000/-. Here B4 should be equivalent to B3, as rebate is restricted up to Rs. 2000/- or equivalent amount of tax payable.
I hope you all catch my point, therefore please do the needful and provide me appropriate formula for B4.
Thanks in advance,
Kumar
