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
|