Manuals/calci/OR - Revision history

Devika at 19:43, 24 August 2018

2018-08-24T19:43:40Z

2018-08-03T22:00:25Z

2018-08-03T21:59:28Z

2018-08-03T21:59:00Z

2017-03-14T11:23:26Z

2015-04-27T01:39:08Z

2013-12-15T02:47:02Z

2013-12-15T02:42:50Z

2013-12-14T23:26:43Z

2013-12-14T23:22:59Z

@@ Line 1: / Line 1: @@
 <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.

@@ Line 3: / Line 3: @@
 *Parameters are logical values or conditions to be tested.
-OR() returns TRUE if any argument is TRUE, and returns FALSE if all arguments are FALSE.
+**OR(), returns TRUE if any argument is TRUE.
 == Description ==

← Older revision		Revision as of 21:59, 3 August 2018
Line 1:		Line 1:
−	~~=OR(l1,l2,...)=~~
	<div style="font-size:30px">'''OR () '''</div><br/>		<div style="font-size:30px">'''OR () '''</div><br/>

@@ Line 1: / Line 1: @@
 =OR(l1,l2,...)=
-*where <math>l1,l2,...</math> are logical values or conditions to be tested.
+*Parameters are logical values or conditions to be tested.
 OR() returns TRUE if any argument is TRUE, and returns FALSE if all arguments are FALSE.
@@ Line 7: / Line 8: @@
 == Description ==
-OR(l1,l2,...)
+OR()
 For Example,
@@ Line 18: / Line 19: @@
 *This function displays the output as TRUE or FALSE.
-*Argument <math>l1</math> is required. <math>l2,l3,...</math> arguments are optional.
+*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.

← Older revision		Revision as of 11:23, 14 March 2017
Line 76:		Line 76:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Bitwise_operation Bitwise Operation]		*[http://en.wikipedia.org/wiki/Bitwise_operation Bitwise Operation]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 62: / Line 62: @@
   =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.
 ==See Also==

@@ Line 19: / Line 19: @@
 *This function displays the output as TRUE or FALSE.
 *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 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 ==
@@ Line 60: / Line 60: @@
   =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 ''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.
 ==See Also==

@@ Line 25: / Line 25: @@
 == Examples ==
 <div id="6SpaceContent" class="zcontent" align="left">
@@ Line 30: / Line 32: @@
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class="sshl_f" |30
+| class="sshl_f" | 30
 | class="sshl_f" |
 | class="sshl_f" |
 |- class="odd"
 | class="sshl_f" |
-| class="sshl_f" |50
+| class="sshl_f" | 50
 | class="sshl_f" |
 |- class="even"
-| class="sshl_f" |
+| class="sshl_f" | 13
 | class="sshl_f" |
 | class="sshl_f" |
 |- class="odd"
-| class="sshl_f" |
+| class="sshl_f" | 20
-| class="sshl_f" |
+| class="sshl_f" | TEXT
 | class="sshl_f" |
 |- class="even"
-| class="sshl_f" |
+| class="sshl_f" | FALSE
 | class="sshl_f" |
 | class="sshl_f" |
 |}
+ =OR(A1=30) :Evaluates the condition for cell A1. Returns ''TRUE'' as an output.
-=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(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.
 ==See Also==