To Jerry Lewis

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
 
B

Biff

Hi Deepak!

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

Biff
 
A

agarwaldvk

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


Best regards


Deepak Agarwa
 
F

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 :)
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Jerry Lewis LUCK ? 1
Sumproduct Function 2
Free Live Online PDU sessions in March2013 0
Sorting Algorithm required! 2
Multiple areas in named ranges 3
Passing variant arrays to C/C++ dll's 0
Custom Functions in C/C++ against in VBA 3
Recalculation takes too long - help!!!! 1

Top