Conditional formulas with multiple possibilites
Hi Mr. T. Valko,
I was searching for this one and have found it useful. Thanking you for the
same.
"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.
|