Difference between revisions of "Manuals/calci/OR"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (11 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''OR () '''</div><br/> |
| + | *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 == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | <div id="6SpaceContent" class="zcontent" align="left"> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="6SpaceContent" class="zcontent" align="left"> | <div id="6SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 30 | |
| − | + | | class="sshl_f" | | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | | |
| − | + | | class="sshl_f" | 50 | |
| − | | class="sshl_f" | | ||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 13 | |
| − | |||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 20 | |
| − | + | | class="sshl_f" | TEXT | |
| − | | class="sshl_f" | | ||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | FALSE | |
| − | |||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
| − | + | =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== | ||
| + | |||
| + | {{#ev:youtube|UpB-oCsnPeM|280|center|OR}} | ||
| + | |||
| + | ==See Also== | ||
| + | |||
| + | *[[Manuals/calci/NOT | NOT]] | ||
| + | *[[Manuals/calci/AND | AND]] | ||
| + | *[[Manuals/calci/TRUE | TRUE]] | ||
| + | *[[Manuals/calci/FALSE | FALSE]] | ||
| + | |||
| + | ==References== | ||
| + | *[http://en.wikipedia.org/wiki/Bitwise_operation Bitwise Operation] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 13:43, 24 August 2018
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
See Also
References