Thread
:
IF Statement
View Single Post
#
1
DME
Posts: n/a
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
Reply With Quote