Thread: formula
View Single Post
  #1   Report Post  
Micayla Bergen
 
Posts: n/a
Default 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