Difference between revisions of "Manuals/calci/AND"

Revision as of 03:14, 5 December 2013

AND(l1,l2...)

This function gives the statement 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.
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 $l1$ is required. $l2,l3...$ are optional.
$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 $AND$ value also should be 1
If either of the logical value is 0(FALSE), then the $AND$ value is 0

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''AND(L1, L2 ...)'''</div><br/>
+<div style="font-size:30px">'''AND(l1,l2...)'''</div><br/>
-*<math>L1,L2...</math> are positive integers.
+*<math>l1,l2...</math> 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 <math>AND(L1,L2,...)</math>, 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, otherwise 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.
 *Suppose in the referred array contains no logical values, then this function will give the result as error.
-*Here the arguments <math>L1</math> is required. <math>L2,L3...</math> 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).