Manuals/calci/OR

OR ()

• Parameters are logical values or conditions to be tested.
  • OR(), returns TRUE if any argument is TRUE.

Description

OR()

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.
• First parameter is required. From second parameter is 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

• List of Main Z Functions

• Z3 home