"OR" operator to evaluate multiple conditions
 

What does a minus sign do? is this a "but not"

anand

"Leo Heuser" wrote:

Scott

It's +

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Scott P" skrev i en meddelelse
...
Is there an arithmetic operator that represents "OR" for use in functions
such as SUMPRODUCT? I am aware that you may use the "*" operator in
SUMPRODUCT to represent an "AND" as in the following case:
=SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate operator to
evaluate "OR" instead of "AND"?

see other question.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"anand" wrote in message
...
What does a minus sign do? is this a "but not"

anand

"Leo Heuser" wrote:

Scott

It's +

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Scott P" skrev i en meddelelse
...
Is there an arithmetic operator that represents "OR" for use in
functions
such as SUMPRODUCT? I am aware that you may use the "*" operator in
SUMPRODUCT to represent an "AND" as in the following case:
=SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate
operator to
evaluate "OR" instead of "AND"?