Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I use OR in a way that true return calculation
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I use OR in a way that true return calculation
Ask a better question.
Give us an example of how you are using the OR function, and what you mean by "true return". -- Regards, Fred "NZRM" wrote in message ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I use OR in a way that true return calculation
"NZRM" wrote apparently;
Subject: how do I use OR in a way that true return calculation In the future, please include your question in the __body__ of your posting, not just the subject. When I saw this inquiry in MS Discussion Groups ( http://www.microsoft.com/communities...s/default.aspx ), I could not even read the complete subject line. Your question is unclear. A concrete example would be helpful. If you mean that you would like OR() to evaluate to 0 for false and 1 for true, there are two ways depending on circumstance. As part of arithmetic expression, nothing special is needed. For example: =OR(A10,B1<0) * SUM(C1:C10) If OR() stands alone, you can use one of the following tricks: =--OR(A10,B1<0) =1*OR(A10,B1<0) On the other hand, if you mean that you would like the result of a calculation returned depending on the OR of two conditions, you could use the first example above, if applicable. Alternatively, try something the following: =IF( OR(A10,B1<0), SUM(C1:C10), SUM(D1:D10) ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using COUNTIF to search for existence | Excel Worksheet Functions | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
How do I make the true return a drop down list in the IF function? | Excel Worksheet Functions | |||
If condition is true return sumproduct of two arrays | Excel Worksheet Functions |