OR FUNCTION

OR FUNCTION

This article describes the formula syntax and usage of the OR function in MS Excel.

Description

Returns TRUE if any argument is True and returns FALSE when all the given conditions or arguments are False.

Formula SYNTAX

=OR(condition1, condition2, …) The OR Function has the following arguments: ·         Condition1 = Required. The first argument in the OR Function is the first condition that you want to test. It can either be evaluated to TRUE or FALSE. ·         Condtion2 = Not Required. This is additional condition that you want to evaluate to either TRUE or FALSE. You can have up to 255 conditions.

REMARKS

·         The conditions defined must evaluate logical values, such as TRUE or FALSE or has array or cell references containing logical values. ·          Array or References that contains text or blank cells are ignored. ·          The AND Function will return the #VALUE! error if there are specific range that contains no logical values.

EXAMPLE 1
=OR(5-3=2,6+2=8)	Returns a value TRUE. The OR Function will return a value TRUE if any of the conditions evaluate to True.
=OR(10<6,5<2)	Returns a value FALSE because all the arguments evaluates to False.
=OR(8*2=16,2+2=6)	Returns a value TRUE. Check the first example for the reason.