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:

Please Login or Register  to view this content.

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

Chance2, that is great!

thank you guys

respect ...