The free guide

OR function in Excel

Use

Tests multiple logical conditions at the same time.

Description

Excel OR functions returns FALSE if the tested conditions are not met otherwise TRUE for conditions evaluated to be right.

Syntax

=OR (logical1, [logical2], …)

logical1 – It is the first condition to evaluate.

[logical2] – The optional argument is the second condition to evaluate.

From 2007 onward Excel’s versions, you can add up to 255  [logical2] tests, however, in 2003 or previous versions, only 30 logical conditions can be tested.

Example

Excel OR function common errors

Excel returns #VALUE! error if the supplied logical test is not interpreted as numeric and logical.

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved