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

If Statement + LEN
 

see previous post.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Krista" wrote in message
...
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 Statement + LEN
 

Try this:

=IF(C26="","",IF(C26="-All
Clubs",54,LEN(C26)-LEN(SUBSTITUTE(C26,";",""))+1))

Biff

"Krista" wrote in message
...
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 Statement + LEN
 

Nice formula <g

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Biff" wrote in message
...
Try this:

=IF(C26="","",IF(C26="-All
Clubs",54,LEN(C26)-LEN(SUBSTITUTE(C26,";",""))+1))

Biff

"Krista" wrote in message
...
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