Multiple conditions using greater than or less than.

[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!

 

[Mike H]

Jane.

This looks at years service in A1 and calculates PTO whatever that is

=LOOKUP(A1,{1,2,3,4,5},{11,16,17,18,22})
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.