Manuals/calci/OR

OR(l1,l2,...)

• where $l1,l2,...$ are logical values or conditions to be tested.

OR() returns TRUE if any argument is TRUE, and returns FALSE if all arguments are FALSE.

Description

OR(l1,l2,...)

For Example,

OR(TRUE,FALSE) returns TRUE

OR(2+3<4,4+1<5) returns FALSE

OR(1,0,1) returns TRUE

• This function displays the output as TRUE or FALSE.
• Argument $l1$ is required. $l2,l3,...$ arguments are optional.
• The conditions mentioned as arguments should evaluate as TRUE(logical 1) or FALSE(logical 0). Else Calci displays an #NULL error message.
• If any one argument is TRUE, calci returns TRUE as output.
• If argument or reference contains text or empty cells, they are ignored.
• If specified range does not contain any logical value, Calci displays an #NULL error message.

Examples

30
	50
13
20	TEXT
FALSE

=OR(A1=30) :Evaluates the condition for cell A1. Returns TRUE as an output.
=OR(A1-30=0,A1>40) :Returns TRUE as first condition is TRUE.
=OR(2*B2=50) :Returns FALSE as an output.
=OR(a+b=c,d+e=f) :Returns #NULL error as both arguments do not evaluate as logical values.
=OR(B3,B4) : Returns FALSE as an output.

Related Videos

OR

See Also

• NOT
• AND
• TRUE
• FALSE

References

• Bitwise Operation