Use of wildcards in formulae
 

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

Use of wildcards in formulae
 

Hi Colin
Try this =IF(COUNTIF(C6,"C*")0,"Yes","No")
HTH
John
"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

Use of wildcards in formulae
 

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

Use of wildcards in formulae
 

=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

Use of wildcards in formulae
 

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