Use of wildcards in formulae

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

Colin Hayes

HI

I need a little advice.

I'm trying to say that if C6 starts with the letter 'C' , then put 'Yes'
, if not put 'No'

I'm using this formula :

=IF(C6="C*","Yes","No")

but it's not giving the correct responses. Can someone advise?

Thanks
 
John said:
Hi Colin
Try this =IF(COUNTIF(C6,"C*")>0,"Yes","No")
HTH
John
Click to expand...

Hi John

Yes , that's fixed it.

Thanks for your help. Much appreciated.


Best Wishes
 
Back
Top