Microsoft Office Tutorials and References
In Depth Information
OR
OR OR returns FALSE if all arguments are False, and TRUE if one argument is True.
=OR(logical1,logical2,...)
The OR function can be used as a stand-alone function when looking for one true statement or
can be used in conjuction with other functions to return logical information. The first
example in Figure 8.5 shows one true test being met in the range D7:F7. The second example
displays no true values in the range D8:F8 and returns the logical value of False. The last
example displays the OR function used in conjunction with the exact function in the form of an
Array. The Array range is D17:D23. If you have a list of ISBN numbers, SKU’s, and so on,
that span 1,000 rows long and you want to know if there is a match with a number, this
formula will tell you if the number exists in the list with a True result. After the formula is
entered, remember to press Ctrl+Shft+Enter to activate the Array.
LOGICAL1, LOGICAL2, ... These are the conditions to be met from 1 to 30 for OR to
test a logical true or false result.
A
TRUE test
B
All tests FALSE
Figure 8.5
The OR function
returns the logical
result of true if only
one true result is met.
C
TRUE match
TRU TRUE returns the value TRUE . There are no arguments associated with this function.
=TRUE()
The TRUE value can be entered directly into cells and formulas without using the function. The
function was included for compatability with other spreadsheet programs.
Search JabSto ::




Custom Search