Constants and Name Textual Display

[Zvi Grinberg]

I'll describe my need.

I want to use constants such as
Good=0
Better=1
Best=2

It is important for me to allow the user to enter (and see) the "words"
as text, and then convert them somehow to numeric values elsewhere
(another sheet, another location)

Eventually I'd like to be able to have a situation for example - where
someone enters "better" in the cell next to the "condition" and
somewhere else have it caculated to 1.

If the solution is other than using constants - it's welcome as well.

Thanks In Advance

 

[Norman Harker]

Hi Zvi!

If I understand correctly, all you need is something like:

=IF(A1="Good",0,IF(A1="Better",1,IF(A1="Best",2,"Only use Good,
Better, Best")))

If you have a lot of alternatives, it might be better to use VLOOKUP

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Don Guillett]

try
=LOOKUP(E2,{"best","better","good"},{3,2,1})