Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement + LEN
I currentl have a formula:
=IF(C26="","",LEN(C26)-LEN(SUBSTITUTE(C26,";",""))+1) But I need to include IF(C26="-All Clubs",54) and am striking out. I need to be able to put the number 54 into the formula field (C27) if C26 contains "-All Clubs" and still have it count the ";" for all other input. Any suggestions? -- THANKS! Krista |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |