Hello,
I have data set consisting information like Salary, Hire Date, Termination Date, Status of employee.
We want to distribute that salary in 12 months and also want to factor 3% increment every year from their joining date and want to factor in condition that if any employee joins in current year, we dont want to give 3% salary raise.
I'm attaching Excel working file for your reference
Current Solution I'm using is
1. First calculation pro rates the salary in 12 month based on hire and termination date
2. Second calculation fulfills 3% increment YOY based on hire date.
Problem
How can combine both formula to make it fully automized calculation by pro rating salary based on Hire and termination date and 3% increments YOY in there base salary until they are active employee
Bookmarks