You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Skibee" wrote in message
...

Thank you very much. That has worked perfectly. Thanks also for laying
it
out so clearly.
Liz
"T. Valko" wrote:

You also need to create a lookup table. Create a 2 column table like
this:

...........A..........B
1.........0........1.0
2....15.1........2.5
3....15.5........4.0
4....16.0........5.5
5....17.0........6.5
6....18.0........7.0

Then:

=VLOOKUP(L7,A1:B6,2)

--
Biff
Microsoft Excel MVP


"Skibee" wrote in message
...
I need to construct a formula with the following parameters:

If L7 is
<=15 return 1.0
between 15.1 and 15.4 return 2.5
between 15.5 and 15.9 return 4.0
between 16.0 and 16.9 return 5.5
between 17.0 and 17.9 return 6.5
between 18.0 and 18.9 return 7.0

and so on.

Any help appreciated.