View Single Post
  #1   Report Post  
anand
 
Posts: n/a
Default "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"?