formula
 

=IF(OR(ISERROR(SEARCH("CMT",A4)),ISERROR(SEARCH("D IVS",A4)),ISERROR(SEARCH("FUND",A4))),"",
IF(LEN(A4)3,1,""))

i have this formula which should return a value of 1 if A5 contains more
than 3 letters except if A5 contains CMT, DIVS or FUND
what am i missing?
many thanks

Well, I'm assuming you mean "A4", not "A5", in your statement. If A4 is the
target cell, try:

=IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","*divs*" ,"*fund*"}))0),"",1)

HTH
Jason
Atlanta, GA

"Micayla Bergen" wrote:

=IF(OR(ISERROR(SEARCH("CMT",A4)),ISERROR(SEARCH("D IVS",A4)),ISERROR(SEARCH("FUND",A4))),"",
IF(LEN(A4)3,1,""))

i have this formula which should return a value of 1 if A5 contains more
than 3 letters except if A5 contains CMT, DIVS or FUND
what am i missing?
many thanks

Perhaps try also:

=IF(ISNUMBER(MATCH(A4,{"CMT";"DIVS";"FUND"},0)),"" ,IF(LEN(A4)3,1,""))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Micayla Bergen" wrote in message
...

=IF(OR(ISERROR(SEARCH("CMT",A4)),ISERROR(SEARCH("D IVS",A4)),ISERROR(SEARCH("
FUND",A4))),"",
IF(LEN(A4)3,1,""))

i have this formula which should return a value of 1 if A5 contains more
than 3 letters except if A5 contains CMT, DIVS or FUND
what am i missing?
many thanks

Really cool Jason, but if the OP really meant "3 letters" instead of "3
characters", then this maybe........

=IF(ISNUMBER(A4),"",IF(OR(LEN(A4)<=3,SUM(COUNTIF(A 4,{"*cmt*","*divs*","*fund
*"}))0),"",1))

Vaya con Dios,
Chuck, CABGx3



"Jason Morin" wrote in message
...
Well, I'm assuming you mean "A4", not "A5", in your statement. If A4 is
the
target cell, try:

=IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","*divs*" ,"*fund*"}))0),"",1)

HTH
Jason
Atlanta, GA

"Micayla Bergen" wrote:


=IF(OR(ISERROR(SEARCH("CMT",A4)),ISERROR(SEARCH("D IVS",A4)),ISERROR(SEARCH("
FUND",A4))),"",
IF(LEN(A4)3,1,""))

i have this formula which should return a value of 1 if A5 contains more
than 3 letters except if A5 contains CMT, DIVS or FUND
what am i missing?
many thanks

If A4 were to contain for example: CMTS or FUNDS or DIVS#
I'm not sure whether the OP would want a "1" to be returned ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----