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.