|
|
|
|
Yeah, I thought of that too.
"KL" wrote:
Chris,
Try going the menu ToolsOptions, selecting the 'View' tab, and uncheking
the 'Formulas' option at the bottom part of the dialog.
Regards,
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!
|