OR

This function calculates logical OR. It returns TRUE if any of its arguments are true; otherwise, returns FALSE if all arguments are false.

Syntax

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

This function has these arguments:

Argument	Description
logical1	[Required] The first condition that you want to test that can evaluate to either TRUE or FALSE.
logical2, ...	[Optional] Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.

OR(B3,B6,B9)

OR(R1C2,R1C3,R1C4,R1C5)

OR(D2:D12)

OR(R12C1:R12C9)

OR(TRUE,FALSE,FALSE) gives the result TRUE

OR(TRUE()) gives the result TRUE

OR(FALSE(),FALSE()) gives the result FALSE

OR(1+1=1,2+2=5) gives the result FALSE

OR(5+3=8,5+4=12) gives the result TRUE