| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF cell A1 contains "X", enter "X" in cell B1, if not enter "Y" HE
The operation I am trying to do is:
If cell A1 contains the word "AMR", I need Excel to show in cell B1 the word "AMR", if it does not find it, enter the word "Other". The word €˜AMR will not be always in the same position in other cells, it can be located anywhere (at the beginning, somewhere in the middle or at the end) on the cell. I tried doing it this way: =IF(A1=*"AMR"*,"AMR","Other") but I got an error message. Does anyone know a formula or another way Excel can do this operation? Any insight would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
