Hi Excel Experts,
I have list of 10 employees who are yet to receive confirmation appraisal for this year, please find attached file.
In Gross Pay Column, salary of particular employee is mentioned.
Rating Criteria: If employee rated 1-3, he will receive 5% hike on his Gross Pay, 4, he will receive 10% hike on his Gross Pay, 5, he will receive 15% hike on his Gross Pay.
(The revised amount should reflect under Confirmation Column)
Suggest a Suitable Formula:
For Rating and Confirmation Columns where if I enter rating between 1-5, excel automatically calculates percentage hike against the gross pay and gives me final value under confirmation column
Example: Mohit Sehgal receives 3, final value( 40,000+5%=42,000 should reflect under confirmation column). I want only be able to enter different ratings under rating column in which confirmation column gives value accordingly.
(Ignore PF Contribution column)
Ratings for each employee available in sheet2.
Thanks and Regards,
Akash Sharma