I am trying to write a formula in Excel that includes the 'search' function and the 'or' function, but I keep getting an error. Here is what I wrote...
The SEARCH Function looks for a substring. As any cell which contains "contacting" will also contain "contact", SEARCH will produce the same result for both. This cannot be what you want, even with correct syntax.
Enjoy,
Tony
-------------------------------------------------------------------------------------------- We want to help you; help us to do it by reading this: Before you ask a question.
Even when you correct your syntax - if SEARCH("contact"G3) gives an error then SEARCH("contact[blue]ing[/blue]"G3) will also give an error - so there is no need for the second SEARCH at all.
Enjoy,
Tony
-------------------------------------------------------------------------------------------- We want to help you; help us to do it by reading this: Before you ask a question.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.