Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"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"? |
#2
|
|||
|
|||
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"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Sum If Multiple Conditions | Excel Worksheet Functions | |||
Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions |