=IF(LEFT(C6)="C","Yes","No")
--
David Biddulph


Colin Hayes wrote:
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