# Weren't no good in math...

## Recommended Posts

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?

##### Share on other sites

Case (

field ≥ 10 ; 2.67 ;

field > 4 ; 2.25 ;

1.83

)

##### Share on other sites

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.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

×
×
• Create New...