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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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