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