merge several formulas in one using OR-function

Andreas Hermle
Andreas Hermle used Ask the Experts™
on
Dear Experts:

I was able to perform a conditional formatting based on these formulas.

I am not quite sure if I could merge all of these expressions in one formula with an OR-Function. Is this possible?

=SEARCH("*von ";D9)
=SEARCH("*van ";D9)
=SEARCH(" ?. ";D8)


Help is much appreciated. Thank you very much in advance.

Regards, Andreas
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
he first formula below is what I tested in US Excel. The second is after conversion (untested) to use semicolon as list separator.T
=OR(ISNUMBER(SEARCH("*von ",D9)),ISNUMBER(SEARCH("*van ",D9)),ISNUMBER(SEARCH(" ?.",D8)))
=OR(ISNUMBER(SEARCH("*von ";D9));ISNUMBER(SEARCH("*van ";D9));ISNUMBER(SEARCH(" ?.";D8)))

Open in new window

Andreas HermleTeam leader

Author

Commented:
Hi byundt, thank you very much for your quick and professional response. Sorry for the delay.  Will see to your post as soon as I get back from my biz trip

Again thankx a lot
Andreas HermleTeam leader

Author

Commented:
Great job, byundt, works as desired. Thank you very much for it. We in Germany have to use the semicolon as list separator.

Again thank you very much for your great help. I really appreciate it. Regards, Andreas
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
I don't have much use for Office-js, but Microsoft has a nifty add-in called Functions Translator in the Office Store that can translate formulas between any pair of supported languages. It will fix both function names and list separators. And it's free.

If you use the German names for functions as well as list separators, the Functions Translator may help you go between what we monolingual Americans post and what you bilingual/trilingual Europeans use.
Andreas HermleTeam leader

Author

Commented:
Hi byundt, good to know, great :-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial