Ctc Break-up In Ms-excel - Xls Download

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
22nd March 2013 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
22nd March 2013 From India, Mumbai

Attached Files (Download Requires Membership)

Copy of Salary Template esic.xls (21.0 KB, 1553 views)