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.
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.
One way:
=IF(COUNTIF(A1,"cott*"),1,0)
or
=--countif(a1,"cott*")
The -- converts true to 1 and False to 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.
--
Dave Peterson
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks