writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 19:
Line 19: − + − + Line 60:
Line 60: − + +
no edit summary
*This function displays the output as TRUE or FALSE.
*This function displays the output as TRUE or FALSE.
*Argument <math>l1</math> is required. <math>l2,l3,...</math> arguments are optional.
*Argument <math>l1</math> is required. <math>l2,l3,...</math> arguments are optional.
*The conditions mentioned as arguments should evaluate as TRUE(logical 1) or FALSE(logical 0). Else Calci displays and error message.
*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 any one argument is TRUE, calci returns TRUE as output.
*If argument or reference contains text or empty cells, they are ignored.
*If argument or reference contains text or empty cells, they are ignored.
*If specified range does not contain any logical value, Calci displays an NaN! error message.
*If specified range does not contain any logical value, Calci displays an #NULL error message.
== Examples ==
== Examples ==
=OR(A1-30=0,A1>40) :Returns ''TRUE'' as first condition is TRUE.
=OR(A1-30=0,A1>40) :Returns ''TRUE'' as first condition is TRUE.
=OR(2*B2=50) :Returns ''FALSE'' as an output.
=OR(2*B2=50) :Returns ''FALSE'' as an output.
=OR(a+b=c,d+e=f) :Returns ''NaN'' error as both arguments do not evaluate as logical values.
=OR(a+b=c,d+e=f) :Returns ''#NULL'' error as both arguments do not evaluate as logical values.
=OR(A4=B4) : Returns ''FALSE'' as an output.
==See Also==
==See Also==