Formula for PAYE Slabs
This query is : Resolved
07 July 2022
Dear All,
Kindly help me in in the formula for PAYE calculation. I tried to write the formula using IF condition, 1st and 3rd Slabs its working fine but 2nd slab its giving wrong figure.
PAYE SCALE %
0 - 24,000.00 10% 0 2,400.00
24,001.00 - 32,333.00 25% 1 854.00
32,334.00 - 30% 0 -
3,254.00
=IF(C224000,C232333,(24000*0.1)+(8333*0.25)+(C2-24000-8333)*0.3)))
Regards
Kancharla Anil
Kindly help me in in the formula for PAYE calculation. I tried to write the formula using IF condition, 1st and 3rd Slabs its working fine but 2nd slab its giving wrong figure.
PAYE SCALE %
0 - 24,000.00 10% 0 2,400.00
24,001.00 - 32,333.00 25% 1 854.00
32,334.00 - 30% 0 -
3,254.00
=IF(C224000,C232333,(24000*0.1)+(8333*0.25)+(C2-24000-8333)*0.3)))
Regards
Kancharla Anil
07 July 2024
The formula for calculating PAYE (Pay As You Earn) tax in Excel is corrected to include IF statements for income ranges and fixed amounts. The formula checks if the income is less than or equal to 24,000. If it is, it calculates PAYE as 10% of the income. If it is greater than 24,000. If it is, it calculates PAYE as a fixed amount from the first two slabs plus 30% of the income exceeding 32,333. The formula assumes income values are inclusive of the upper limit of each slab.
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
- CAPITAL GAIN BASE ON NOTIFICATION
- Taxable or Tax exempt
- TDS Deducted AY-2013-14 Not Reflected in 26as
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Demand Outstanding AY 2013-14 TDS Deducted not shown in 26as
- ADVANCE PAYMENT OF ADVOCATE
- Goods sold but invoice not issued
- GST rate and HSN code for sale of racing horses
- Condonation . E-Verification of last year return .
- Capital gain on sale and purchase of plot
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
