If Statments containing letters
how about if you use:
=IF(LEFT(A26,4)="COTT",1,0)
"Rick Wiley" wrote:
How do I create an IF statement that contains letters.
eg. Cell A1 "COTTONELLE 24 ROLL".
IF(A1="COTT*",1,0).
The ultimate goal is to create Conditional Formatting for specific brands.
|