If Then Function with text
AHH!!! Thank you!
"JE McGimpsey" wrote:
One way:
=IF(A1="B","consumer",IF(A1="C","real estate",
IF(A1="V","Visa","Other")))
In article ,
"Karen" wrote:
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?
|