You're welcome .
Regards
John
"Colin Hayes" wrote in message
...
In article , John
writes
Hi Colin
Try this =IF(COUNTIF(C6,"C*")0,"Yes","No")
HTH
John

Hi John

Yes , that's fixed it.

Thanks for your help. Much appreciated.


Best Wishes


"Colin Hayes" wrote in message
...

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