Difference between revisions of "Manuals/calci/AND"

From ZCubes Wiki
Jump to navigation Jump to search
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<div style="font-size:30px">'''AND(L1, L2 ...)'''</div><br/>
+
<div style="font-size:25px">'''AND(l1,l2...)'''</div><br/>
  
*L1,L2... are positive integers.
+
*<math>l1,l2...</math> are conditions to test.
  
 
==Description==
 
==Description==
 
*This function gives the statement TRUE or FALSE.
 
*This function gives the statement TRUE or FALSE.
 
*AND function is calculating our arguments to logical values such as TRUE or FALSE.
 
*AND function is calculating our arguments to logical values such as TRUE or FALSE.
*In AND(L1,L2,...), if all the values of the arguments are TRUE, the function returns TRUE, otherwise FALSE.
+
*In <math>AND(l1,l2,...)</math>, if all the values of the arguments are TRUE, the function returns TRUE.
*If any one of the argument is false, then the function returns FALSE.
+
*If any one of the argument is FALSE, then the function returns FALSE.
 
*Any text or any empty cells are in the referred argument, then those values are ignored.
 
*Any text or any empty cells are in the referred argument, then those values are ignored.
 
*Suppose in the referred array contains no logical values, then this function will give the result as error.
 
*Suppose in the referred array contains no logical values, then this function will give the result as error.
*Here the arguments L1 is required. L2,L3... are optional.
+
*Here the arguments <math>l1</math> is required. <math>l2,l3...</math> are optional.
 
+
*<math>AND</math> is a function which returns as 1(TRUE) when all its arguments are 1 (TRUE).  
 
+
*If one or more argument is 0(FALSE), then <math>AND</math> is calculated as 0(FALSE).
*And is a function which returns as 1(TRUE) when all its arguments are 1 (TRUE). If one or more argument is 0(FALSE), then AND is calculated as 0(FALSE).
+
*If both the logical values are 1(TRUE), then <math>AND</math> value also should be 1
 
+
*If either of the logical value is 0(FALSE), then the <math>AND</math> value is 0
If both the logical values are 1(TRUE), then AND value also should be 1 and either of the logical value is 0(FALSE), then the AND value is 0
 
 
 
  
 +
==ZOS==
 +
*The syntax is to calculate AND in ZOS is <math>AND(l1,l2..)</math>.
 +
**<math>l1,l2...</math> are conditions to test.
 +
*For e.g.,AND(0.5+0.75<0,10+2<16)
 +
*AND(0.5-0.75<0,10+2<16)
 +
{{#ev:youtube|WEqH6DqRLuc|280|center|Datevalue}}
  
 
==Examples==
 
==Examples==
AND(TRUE,TRUE)=TRUE
+
*=AND(TRUE,TRUE) = TRUE
AND(FALSE,FALSE)=FALSE
+
*=AND(FALSE,FALSE) = FALSE
AND(2+3<10,-4-5<0)=TRUE
+
*=AND(2+3<10,-4-5<0) = TRUE
AND(1/2=0.5,1*-2=2)=FALSE
+
*=AND(1/2=0.5,1*-2=2) = FALSE
AND(a+b=c,d+e=f)=NAN, because L1,L2 are not a logical  values
+
*=AND(a+b=c,d+e=f)=NAN, because l1,l2 are not a logical  values
70
 
150
 
AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
AND (L)
 
 
 
=AND (1,1) is 1 ie, TRUE and =AND(1,0) is 0. ie, FALSE
 
  
B
+
*Let A1= 70, =AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125
  
55
+
==Related Videos==
  
110
+
{{#ev:youtube|HywvbEzekmA|280|center|AND}}
  
=AND(1&lt;B3,B3&lt;100) is 1(TRUE)
+
==See Also==
 +
*[[Manuals/calci/NOT | NOT]]
 +
*[[Manuals/calci/OR  | OR]]
  
=IF(AND(1&lt;B4,B4&lt;100, B4, "The value is out of range.") is out of range
+
==References==
 +
*[http://en.wikipedia.org/wiki/Bitwise_operation  Bitwise Operation]

Latest revision as of 14:06, 7 June 2015

AND(l1,l2...)


  •  are conditions to test.

Description

  • This function gives the statement TRUE or FALSE.
  • AND function is calculating our arguments to logical values such as TRUE or FALSE.
  • In , if all the values of the arguments are TRUE, the function returns TRUE.
  • If any one of the argument is FALSE, then the function returns FALSE.
  • Any text or any empty cells are in the referred argument, then those values are ignored.
  • Suppose in the referred array contains no logical values, then this function will give the result as error.
  • Here the arguments is required. are optional.
  • is a function which returns as 1(TRUE) when all its arguments are 1 (TRUE).
  • If one or more argument is 0(FALSE), then is calculated as 0(FALSE).
  • If both the logical values are 1(TRUE), then value also should be 1
  • If either of the logical value is 0(FALSE), then the value is 0

ZOS

  • The syntax is to calculate AND in ZOS is .
    • are conditions to test.
  • For e.g.,AND(0.5+0.75<0,10+2<16)
  • AND(0.5-0.75<0,10+2<16)
Datevalue

Examples

  • =AND(TRUE,TRUE) = TRUE
  • =AND(FALSE,FALSE) = FALSE
  • =AND(2+3<10,-4-5<0) = TRUE
  • =AND(1/2=0.5,1*-2=2) = FALSE
  • =AND(a+b=c,d+e=f)=NAN, because l1,l2 are not a logical values
  • Let A1= 70, =AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125

Related Videos

AND

See Also

References