Yes, but here is the text of the response. The formula he suggested is as
follows:
=IF(A1=40,3,IF(A1=30,2,IF(A1=20,1,0)))

Response:
This is great! I have a problem though. The desired value does not display in
the cell this formula is entered into.

If I enter 23 in A1, all I see in A2 (where the forumla is located) is the
forumla itself. Looking at the formula's logical test, the only time
"Value_if_false" is reported with a value is when A1<20. How do I set it so
it only shows what is true, and disregards a false result EXCEPT when A1<20?

Does that make sense?


"KL" wrote:

Can't see the response to Biff :-(
Have you already posted it?

KL


"Chris McDannold" wrote in
message ...
Wonderful! However, please see the response to Biff below as I am having
the
same problem when entering your formula.
Thanks again!

"KL" wrote:

Hi Chris,

Option 1:
Create a table, say in range A1:B3, like this:

20 1
30 2
40 3

if in cell C1 you manually introduce a serched value, then in cell D1
input
the following formula:

=VLOOKUP(C1,$A$1:$B$3,2)

Option 2:
No table necessary, just use the following formula:

=VLOOKUP(C1,{20,1;30,2;40,3},2)

Option 3:
No table necessary, just use the following formula:

=INDEX({1,2,3},MATCH(C1,{20;30;40}))

Regards,
KL

"Chris McDannold" <Chris wrote in
message ...
OK, I am not sure how to even begin to search for this because I am
unsure
of
the nomenclature I need to look for. That said, here is what I am
looking
to
understand:

I need to display a value of "1" if a total (manually entered in an
adjacent
cell) is 20-29; "2" if a total is 30-39; and "3" if a total is 40+. So
if
the
entered value is 25, the value displayed in the adjacent cell would be
"1".

Can and how do I do this?
Many thanks in advance!