Djblois
11-12-2009, 09:11 AM
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?