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

Vaya con Dios,
Chuck, CABGx3


"Karen" wrote in message
...
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?