OR(logical1 [,logical2] [..])

Returns the logical OR for any number of arguments.

logical1The first logical value.
logical2(Optional) The second logical value.

Remarks

* This function returns either True or False.
* The logical values can be constants, logical equations, cell references or named ranges.
* The arguments must evaluate to logical values such as True or False, or in arrays or references that contain logical values.
* If an array or reference argument contains text or empty cells, those values are ignored.
* If the specified range contains no logical values, OR returns the #VALUE! error value.
* You can have a maximum of 255 arguments.
* You can use the AND function to return the logical AND for any number of arguments.
* You can use the NOT function to return the opposite of a True or False value.
* You can use the XOR function to return the logical exclusive OR for any number of arguments.
* For the Microsoft documentation refer to support.office.com

 A
1=OR(TRUE) = True
2=OR(1+1=1,2+2=5) = False
3=OR(FALSE,FALSE,FALSE,TRUE) = True
4=OR(1,1,0,0,0,1,1) = True
5=OR({FALSE,FALSE,FALSE}) = False
6=OR({TRUE,FALSE}) = True
7=OR({FALSE},{FALSE}) = False
8{=OR({FALSE,FALSE},{TRUE,TRUE})} = TRUE


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top