Jump to content
Sign in to follow this  
cferri2005

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 this post


Link to post
Share on other sites

Case (

field ≥ 10 ; 2.67 ;

field > 4 ; 2.25 ;

1.83

)

Share this post


Link to post
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.

Lookup based on range

Share this post


Link to post
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

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

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.