G
Guest
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
=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