If formula
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
11 August 2010
Dear Members
please provide Formula for calculating Income tax in Excel for different slab rates.
please provide Formula for calculating Income tax in Excel for different slab rates.
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.
Please check above files.
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.
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- Is Aadhar PAN linking required for opening bank account?
- Applicability
- Where to show the RCM on Rent paid to unregistered landlord
- RCM - commercial rent paid to URP under GST
- TDS NUMBER SURRENDER
- Application of 115BAC
- Gst Sales of FY 2023-24
- Legal heir raised refund , but refund issued to the closed account of deceased.
- Offsetting interest income against derivative trading losses
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding Resignation by Auditor from Pvt. Ltd.
- Regarding einvoice taken on nil rated sales
- Strategical investment in Public listed company
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
