If Then Function with text

K

Karen

I am not sure if this is possible. I would like to return a value of
"consumer," "real estate", or "Visa" dependant on if another cell is equal to
B, C, or V. I get the error message ?NAME... so I am not sure if this is the
right formula - because the IF/Then needs numberical data or if it is
possible! Any ideas?
 
J

JE McGimpsey

One way:

=IF(A1="B","consumer",IF(A1="C","real estate",
IF(A1="V","Visa","Other")))
 
C

CLR

=IF(A1="B","consumer",IF(A1="C","real estate",IF(A1="V","Visa","")))

Vaya con Dios,
Chuck, CABGx3
 
P

Pete

Assume your B C or V values are in cell A2, the following formula will
give you what you want;

=IF(A2="B","Consumer",IF(A2="C","Real Estate","Visa"))

This assumes that only the values B C or V can exist in A2.

You probably got the ?NAME error by omitting the "" around the B etc,
so Excel was looking for a named range.

Pete
 
Top