PRIME SPONSOR - FACTOHR - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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

Attached Files
Membership is required for download. Create An Account First
File Type: xls Copy of Salary Template esic.xls (21.0 KB, 1408 views)

PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™