| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
