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