I am working on an employee PTO and time off schedule, and I am having a bit trouble working out a calculation formula for the PTO/month value based on the amount of years that they have been employed.

For instance; If an employee has worked here 4 years or less they earn 1.83 days off per month.

5 - 9 years, and they earn 2.25..and if they work 10 or more years, they earn 2.67

I'll give a quick run down of what I want and see if anyone knows where I should start.

****

If the value of a field is less than or equal to 4, then enter a value of 1.83

If the the value of a field is greater than 4 but less than 10, then enter a value of 2.25

If the value of a field greater than or equal to 10, then enter a value of 2.67

****

Did I confuse anyone? Any suggestions?

Case (

field ≥ 10 ; 2.67 ;

field > 4 ; 2.25 ;

1.83

)

This thread is related and should give you the basic idea. It you cant figure it out from that, come back with the specifc questions and we'll see if we cant help you out further.

Good luck.

Lookup based on range