Nested functions

**piquet2759** · 08-16-2009, 03:59 AM

How do I create a function that works out if a number falls between say 100 and 287 then the result is "Apples". If the number entered is between 288 and 387 then the answer is "bananas" And so on. I tried a nested function but it only had seven entries. I need to enter 100 possible ranges up to 9000.

Any help would be greatly appreciated

Thanks
piquet2759

**DonkeyOte** · 08-16-2009, 04:07 AM

Given you have so many values - create a table with lower value of each threshold in one column and associated word in adjacent column, eg

100	Apples
288	Bananas
388	Carrots
etc...

If we assume above table were in say cells C1:D100 (100 ranges) and we assume the number of interest is cell A1, eg:

A1: 123

then

B1: =VLOOKUP($A1,$C$1:$D$100,2)