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

"David Biddulph" wrote:

"" 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?
--
David Biddulph

"Dimple" wrote in message
...
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.

"Teethless mama" wrote:

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


"Dimple" wrote:

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