IF and Then Formula Help Needed Please

[Dimple]

I need some assistance. Here's what I'm trying to do:
I have a column with years of service for all our employees, say it's column
D. Column E needs to say what their accural rate for vacation time is
depending on their length of service. So if the years of service is less than
3, accural is 4.62. If it's between 3 and 7 years, accural rate is 5.54. If
it's between 7 and 14 years, accural rate is 6.46. If years of service are
greater then 14, accural rate is 7.39.
Here's what I have, but it's not working:
IF(D3<3,4.62),IF(3.1<D3<7,5.54),IF(7.1<D3<14,6.46),IF(14.1<D3,7.39)

Please help.
Thank you,
Dimple

 

[Teethless mama]

=IF(D3="","",LOOKUP(D3,{0,3,7,14},{4.62,5.54,6.46,7.39}))

 

[Dimple]

First, Thank you for responding. But I'm not quite sure what the "" are
suppose to mean. I tried entering this as is and nothing came up.

 

[David Biddulph]

"" is an empty string, and the first part of the formula is saying that if
D3 is empty, the result is empty.
Without that you can get problems with the lookup if you put an empty string
as the input to the lookup function.

What do you mean by "nothing came up"? Have you pasted the formula directly
from the NG into your formula bar, or have you mistyped it? What number do
you have in D3 and what result does your formula give?

 

[ryguy7272]

"" is also known as double quotes. It just means blank cell, null, no data,
etc. You are saying, if the cell is blank, return a blank, otherwise do the
Lookup operation, which assigns the criteria in the first set of curly
brackets to the criteria in the second set of curly brackets. Just try a few
different scenarios and see the the results are. I think you will figure it
out pretty quickly.


Regards,
Ryan--

 

[Dimple]

Thank you so much. I had just tried it to the one scenario I shouldn't have.
I applied to the correct info and it worked beautifully!! Thanks so much!!
Dimple