Save Rs 499 on a 2-Year Ad-Free CAclubindia Pro Membership. Subscribe Now!

If formula

Save Share

Join Us Follow Us Add as Source

This query is : Resolved

Report Follow Query Ask a Query

Querist : Anonymous

Querist : Anonymous (Querist)

11 August 2010 Dear Members

please provide Formula for calculating Income tax in Excel for different slab rates.

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

11 August 2010 https://www.caclubindia.com/share_files/files_display_search_results.asp?search_txt=income+tax+calculator+ay+10-11&x=28&y=12

Please check above files.

CMA. Subhash Kumar Jha

CMA. Subhash Kumar Jha (Expert)
Follow

11 August 2010 =ROUND(IF(+B33>800000,(+B33-800000)*0.3+94000,IF(+B33>500000,(+B33-500000)*0.2+34000,IF(+B33>160000,(+B33-160000)*0.1))),0)

Here B33 is the cell of Net Taxable salary. & this formula is for Male but not senior citizen.

=ROUND(IF(+U33>800000,(+U33-800000)*0.3+91000,IF(+U33>500000,(+U33-500000)*0.2+31000,IF(+U33>190000,(+U33-190000)*0.1))),0)

Here U33 is the cell of Net Taxable salary. & this formula is for Female but not senior citizen.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!