I am working on the subject in order to revise the existing CTC structure. In doing so, the special allowance, which balances the CTC fitment, is a figure that is a component of Monthly Gross Salary and on which Employer ESIC Contribution is dependent. I need to work out a formula "@IF(....)" for the Special Allowance cell to complete this fitment appropriately. Please assist.

Regards,
Lancy Menezes
Manager - HR & Administration
Mobile: +91 8879508614

From India, Mumbai
Acknowledge(0)
Amend(0)

Dear Lancy, I had worked on one assignment and had prepared such excel as per the rule.Please find the attached sheet hope you find it suitable. if you wish to know more do revert. regards RD
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Copy of Salary Template esic.xls (21.0 KB, 1631 views)

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.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.