using wildcards in Formulas

[Djblois]

I am creating an IF formula that looks in a cell and if the Cell begins with CRN then it should be true. I tried =If(C1="CRN*", "Action if True", "Action if False") but that doesn't work. How do I get it to be True if it begins with CRN?

[Bob Phillips]

Try

=IF(LEFT(C1,3)="CRN","Action if True","Action if False")