I am working on subject in order to revise the existing CTC structure. In doing so, the special allowance which balances the CTC fitment is a figure which 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 88795 08614

From India, Mumbai
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
File Type: xls Copy of Salary Template esic.xls (21.0 KB, 1467 views)

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

CiteHR
Please Login To Add Reply






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server