Link to home
Start Free TrialLog in
Avatar of Andreas Hermle
Andreas HermleFlag for Germany

asked on

merge several formulas in one using OR-function

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
Avatar of byundt
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Andreas Hermle


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
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
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.
Hi byundt, good to know, great :-)