writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + + +
no edit summary
<div style="font-size:30px">'''AND(L1, L2 ...)'''</div><br/>
<div style="font-size:30px">'''AND(L1, L2 ...)'''</div><br/>
*L1,L2... are positive integers.
*<math>L1,L2...</math> are positive integers.
==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, otherwise FALSE.
*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.
*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).
*<math>AND</math> is a function which returns as 1(TRUE) when all its arguments are 1 (TRUE).
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
*If one or more argument is 0(FALSE), then <math>AND</math> 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
==Examples==
==Examples==