To Jerry Lewis

  • Thread starter Thread starter agarwaldvk
  • Start date Start date
A

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
 
Hi Deepak!

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

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


Best regards


Deepak Agarwa
 
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 :-)
 
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
 
Back
Top