Dec 29 2021 09:02 AM
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
Dec 29 2021 09:20 AM - edited Dec 29 2021 09:23 AM
SolutionPlease 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)))
Dec 29 2021 09:33 AM
Dec 29 2021 09:20 AM - edited Dec 29 2021 09:23 AM
SolutionPlease 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)))