SOLVED

Formula Help

Copper Contributor

Hello,

 

I'm trying to set a vacation tracker to populate vacation days based on years worked.  

0-4 years = 10

5-14 = 15

15-24 = 20

>25 = 25

 

I want the formula to populate one of those values based on the the employees start date.  I'm not very fluent in excel.

 

I thought an "IF AND" formula would work but it doesn't.  I tried below: 

 IF(AND(T5>=0,T5<=4),"10"),IF(AND(T5>=5,T5<=14),"15"),IF(AND(T5>=15,T5<=24),"20"),IF(AND(T5>=25),"25")

 

If I do just:

IF(AND(T5>=0,T5<=4),"10")

it works fine.

 

Any assistance would be appreicated.


Thank you

3 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Steve_G12 

Please try it like this...

 

=IF(AND(T5>=0,T5<=4),10,IF(AND(T5>=5,T5<=14),15,IF(AND(T5>=15,T5<=24),20,25)))

 

Or simply this...

=IF(T5<=4,10,IF(T5<=14,15,IF(T5<=24,20,25)))

 

Thank you!!! I figured it had something to do with my parenthesis. I appreciate the help and the quick response!

You're welcome @Steve_G12! Glad I could help.

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Steve_G12 

Please try it like this...

 

=IF(AND(T5>=0,T5<=4),10,IF(AND(T5>=5,T5<=14),15,IF(AND(T5>=15,T5<=24),20,25)))

 

Or simply this...

=IF(T5<=4,10,IF(T5<=14,15,IF(T5<=24,20,25)))

 

View solution in original post