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
- Refund Annexure-B
- Liable to deduct tds and 44ADA
- Sale of Equity shares for Purchase of Residential Property
- Nomination of Bank for refund in itr 2
- Section 56(2) of the Income tax Act 1961 , Gift to relative .
- ECO SUPPLY REPORTIONG IN GSTR-1
- Is Interest applicable for payment made through credit ledger vide DRC03 for FY 2020-21 & 2021-22
- CCFS 2026 Schemed
- Subscription paid to foreign customer
- Two seprate Invoice needed
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
