Baiju G Nath
New Member
Hi Excel Experts,
I am excited to be in the forum to learn and contribute. This is my first post in this forum.
I am working on a salary break up calculator. I am trying to find a formula for Basic and special to fix this.
The CTC is : Fixed salary + Retirals & Incentive.
Basic is 40% of Fixed Salary and not CTC
Incentive is a % of the CTC
I have attached an excel file for your ready reference. I would appreciate if the experts in this forum can crack this for me.
Regards
Baiju
I am excited to be in the forum to learn and contribute. This is my first post in this forum.
I am working on a salary break up calculator. I am trying to find a formula for Basic and special to fix this.
The CTC is : Fixed salary + Retirals & Incentive.
Basic is 40% of Fixed Salary and not CTC
Incentive is a % of the CTC
I have attached an excel file for your ready reference. I would appreciate if the experts in this forum can crack this for me.
Regards
Baiju