Okay so I am trying to create a formula that can take calculate cost of a PTO program. Here is some info.
We have a standard PTO plan that give 40 hour PTO per year 1, 1- 4 years is 80, 5-9 is 120, and 10+ is 160.
We allow people to negotiate PTO so we have plans that are standard plus 1 or plus 2 or plus 3
I need to calculate the cost for the remaining of the year and the cost until the person gets to where they should be.
So if they are on the standard plus 1 plan and have less than 1 year at organization they get 40 plus an additional 40. I am attaching my spreadsheet that has the information. Any help would be great. I am trying to find the multiplier in column AC to get me there.
Any Help is appreciated.
Bookmarks