Assuming that 29.8 is still mapped onto 1 and disregarding a simpler
rounding solution for a moment...

=LOOKUP(A2,{-9.99999999999999E+307,0;20,1;30,2;40,3;"
",0})

would cover a bit more that is desirable to have.

Note that "
" is the result of =CHAR(1).

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!




--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.