To Jerry Lewis

[agarwaldvk]

Jerry

To one of my queries with reference to "complicated formula", yo
indicated that the '+' in your suggested solution served the purpose o
the logical OR. That is OK!

And would that solution of yours would have worked just as good wit
the standard OR(condition1, condition2) functionality?

Further, is there an equivalent of '+' for the logical AND?

Best regards



Deepak Agarwa

 

[Biff]

Hi Deepak!

I can answer this part of your post. It would be the
multiplication operator: *

Biff

 

[agarwaldvk]

Thanks Biff! That's great! Any inkling on the other bit?


Best regards


Deepak Agarwa

 

[Frank Kabel]

Hi
this would be difficult as we do not know which formula JE provided to
you. You have started a new thread instead of staying in the
old/existing one

 

[Bernard Liengme]

As Frank points out, we do not know the context. However, you should know
that AND and OR cannot be used in array formulas while the operators (* and
+) can be.
Best wishes