Thread: problem with number ranges

hey guys,

i'm using a table like this:

1 to 10% |11 to 20%| 21 to 30%
good | well | very well

if for examp. i put in a textbox a percentage between 1 and 10 it must write "good" and so ...


thanks in advance for help
regards

Make a reference list Column A/Column B:
1/Good
11/Well
21/Very well

Say you are putting your value in cell F2, put this formula in G2:
=LOOKUP(F1,A1:B3)

If you plug in "5" into F2, the formula will result with "Good", "15" with "Well" and so forth.

You could just use the LOOKUP formula with your variables/results as part of the formula:

Code:

=LOOKUP(A1,{1,11,21},{"Good","Well","Very Well"})

Where the LOOKUP VECTOR is the low end of the range you are looking for.

Chance2, that is great!

thank you guys

respect ...