"" 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--

--
RyGuy


"Dimple" wrote:

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