Hi all,
I am working on compa-ratios but I wanted it based on the number of years that an employee is in their current position.
Instead of looking at their years and manually entering the corresponding percentage, I wanted to set up an excel formula that says, IF column J <1, then 85%, IF column J is 1-2, then 88%, IF column J is 2-3, then 91%, etc.
Time in position:
Column J- years
Columns k - the percentage should auto-populate based on J
0-1 year – 85%
1-2 years - 88%
2-3 years - 91%
3-4 years - 94%
4-5 years - 97%
5 years - 100%
6-7 years - 102%
7-8 years - 104%
8-9 years - 106%
10+ years - 108%
Thanks in advance!
Bookmarks