Vacation time earned per year

Rey721

New Member
Joined
Oct 23, 2019
Messages
3
Hi
I'm trying to create a table were it maintains the vacation time earned based of year of service. We calculate the time:

5 years or less = 80 hrs./year
6-14 years = 120 hrs./year
15+=160 hrs./year

i seem to be stuck on creating the formula, and the examples i found didn't help. please let me know if anyone can help or point me to the right direction.
thank you in advance
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Tricepsratops

New Member
Joined
Jan 3, 2020
Messages
45
Office Version
  1. 365
Platform
  1. Windows
Try to take a look at the IFS function


If you post a sample of your data I can help you further.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,561
Messages
5,548,743
Members
410,868
Latest member
Dhanas
Top