Struggling with Excel Formulas for PT and ESIC Deductions? Let's Figure It Out Together

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

Here is a formula; however, please cross-check before implementing:

=IF(A5>9999, 200, IF(A5>5001, 175, IF(A5<5000, 0, 0)))

Regards,
Atif

One change.

Formula for PT and ESIC Deductions

=IF(A5 > 9999, 200, IF(A5 > 5001, 175, IF(A5 < 5000, 0, 0)))

A5 is the gross amount.

Regards,
Viraj