formula w exception

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

can i have a formula that looks for one thing but with exceptions?
i.e. =IF(LEN(A5)>3,1,"") but if A5 contains CMT, DIVS or FUND
many thanks
 
=IF(OR(ISERROR(SEARCH("CMT",A5)),ISERROR(SEARCH("DIVS",A5)),ISERROR(SEARCH("FUND",A5)),
IF(LEN(A5)>3,1,""), "" )
best wishes
 
Thanks Bernard. however i get an error saying there is a missing parenthesis,
so i have added one to the end, then i get a formula message saying i am
missing the value if true value if false values
 
so i have tried thi
=IF(OR(ISERROR(SEARCH("CMT",A6)),ISERROR(SEARCH("DIVS",A6)),ISERROR(SEARCH("FUND",A6))),,IF(LEN(A6)>3,1,""))
and still get nothing
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula 4
Excel formula, sum the value cell and if empty cell left blank 0
Deselect a cell in a discontiguous range 3
formula with {} 5
Copy a formula using Vlookup 2
aNOTHer troublesome equation 7
Mandatory and optional formula 5
Formula Content linked to other cells formula Content 5

Back
Top