Dear HR Members,
I am working on salary calculations in Excel and require assistance with formulas for calculating PT and ESIC deductions. If the gross amount is more than 5000, it should deduct 175, and if it exceeds 10000, the deduction should be 200. For values less than 5000, there should be no deduction. The same criteria apply to ESIC deductions.
Regards,
Dilip
From India, Pune
Acknowledge(0)
Amend(0)
7I am working on salary calculations in Excel and require assistance with formulas for calculating PT and ESIC deductions. If the gross amount is more than 5000, it should deduct 175, and if it exceeds 10000, the deduction should be 200. For values less than 5000, there should be no deduction. The same criteria apply to ESIC deductions.
Regards,
Dilip
From India, Pune
Acknowledge(0)Amend(0)
Here is a formula, however plz cross check before implementing =IF(A5>9999,200,IF(A5>5001,175,IF(A5<5000,0,0))) Regards Atif
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Dilip, One change. =IF(A5>9999,200,IF(A5>=5001,175,IF(A5<5000,0,0))) A5 is the gross amount. Regards, Viraj
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls
SALARY EXCEL.zip