J
Jane
I am trying to create a formula to help me with the below scenerio.
I need to calculate how many days of PTO time someone would get based on
years of service.
the years of service cell is less than 2, the employee gets 11 days of pto
if the years of service =2 or anything up to 3, the employee gets 16 days of
pto
if the years of service is =3 or anything up to 4, the employee gets 17 days
of pto
if the years of service is =4 or anthing up to 5, the employee gets 18 days
of pto
if the years of service is from 5-19 years, the employee gets 22 days of pto
I think you can see the pattern from this partial information.
Any guidance would be much appreciated!
I need to calculate how many days of PTO time someone would get based on
years of service.
the years of service cell is less than 2, the employee gets 11 days of pto
if the years of service =2 or anything up to 3, the employee gets 16 days of
pto
if the years of service is =3 or anything up to 4, the employee gets 17 days
of pto
if the years of service is =4 or anthing up to 5, the employee gets 18 days
of pto
if the years of service is from 5-19 years, the employee gets 22 days of pto
I think you can see the pattern from this partial information.
Any guidance would be much appreciated!