| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Statement
IN cell a1 I have CP-Barge
In B1 I want a formula that says IF A1 contains CP then Enter CP into cell B1otherwise leave it Blank I have tried =IF(a1="*CP*","CP","") but it does not work. Thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Report Using IF Statement? | Excel Discussion (Misc queries) | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
| when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
| Combining SUM Function with Nested If Statement | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Threaded Mode
