SOLVED

New Contributor

Formula Help

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 Sergei Baklan (MVP)
Solution

Re: Formula Help

``=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)))``

Re: Formula Help

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

Re: Formula Help

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