Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then Function with text
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then Function with text
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then Function with text
=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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then Function with text
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif function for instances of text string contained | Excel Worksheet Functions | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
How to Insert function right on text values e.g. 0180001640 | Excel Worksheet Functions | |||
How do I add help text to an excel function I have created | Excel Worksheet Functions | |||
Function within a TEXT FORMULA | Excel Worksheet Functions |