| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If Statments containing letters
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. |
|
#2
|
|||
|
|||
|
If Statments containing letters
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 |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
| random combination of letters | Excel Worksheet Functions | |||
| Counting the number of letters in a cell | Excel Discussion (Misc queries) | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
