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(2)
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(2)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(1)Amend(0)
From India, Mumbai
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY EXCEL.zip
PT,ESIC,TDS,FBT ,S[1][1].Tax Calculator.xls