Free Online Tutorials on Spreadsheets

OR function in Excel


Tests multiple logical conditions at the same time.


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


=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.


Excel OR function common errors

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

Copyright © 2016 - 2019 | All Rights Reserved