Introduction

The OR Function is used as a logical function to check multiple conditions at the same instant. OR provides value in the form of TRUE or FALSE. OR function can be used with IF function to remove complexity of multiple nested IF’s and is also used with function AND.

Syntax

=OR (value1, value2, …)

Arguments

value1 – It is the 1^st value (logical) that will be processed.

value2 –  It is the 2^nd value (logical) that will be processed.

Logical operator

We can use the following operators while using OR.

Operator	Value
=	Equal to
>	Greater than
>=	Greater than or Equal to
<	Less than
<=	Less than or Equal to
<>	Not equal to

Keynotes

• Use the OR to check multiple conditions at the same instant. You can check up to 255 conditions altogether.
• If you enter OR as array formula, you will be able to test all the values in a defined range against a given condition.
• The OR function will return #VALUE if no logical values are found

Examples

Here, the statement is testing two criteria. Firstly we will check whether paid amount is less than total amount (D<B), Then we will check if the payment had been made within a month of issuing the invoice (E-C>30). If one of the criteria matches than value will come out to be TRUE and if none of the criteria matches than value will come out to be false .(See the 4^th and 6^th Row of Image)