Difference between revisions of "Manuals/calci/AND"

From ZCubes Wiki
Jump to navigation Jump to search
Line 26: Line 26:
  
 
==See Also==
 
==See Also==
 
 
*[[Manuals/calci/NOT | NOT]]
 
*[[Manuals/calci/NOT | NOT]]
 
*[[Manuals/calci/OR  | OR]]
 
*[[Manuals/calci/OR  | OR]]
*[[Manuals/calci/TRUE | TRUE]]
 
*[[Manuals/calci/FALSE | FALSE]]
 
  
 
==References==
 
==References==
 
*[http://en.wikipedia.org/wiki/Bitwise_operation  Bitwise Operation]
 
*[http://en.wikipedia.org/wiki/Bitwise_operation  Bitwise Operation]

Revision as of 00:56, 9 June 2014

AND(l1,l2...)


  •  are positive integers.

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

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

See Also

References