Difference between revisions of "Manuals/calci/AND"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font face="Times New Roman"> </font> AND (L1, L2 ...) Where L1, L2''' …''' are positive integers. </di...") |
|||
| (15 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:25px">'''AND(l1,l2...)'''</div><br/> |
| − | + | *<math>l1,l2...</math> 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 <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. | ||
| + | *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. | ||
| + | *<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). | ||
| + | *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 | ||
| − | + | ==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}} |
| − | < | ||
| − | AND | + | ==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== | |
| − | + | {{#ev:youtube|HywvbEzekmA|280|center|AND}} | |
| − | + | ==See Also== | |
| + | *[[Manuals/calci/NOT | NOT]] | ||
| + | *[[Manuals/calci/OR | OR]] | ||
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Bitwise_operation Bitwise Operation] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 13:06, 7 June 2015
AND(l1,l2...)
- are conditions to test.
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
, if all the values of the arguments are TRUE, the function returns TRUE.
is required. 
are optional.
is a function which returns as 1(TRUE) when all its arguments are 1 (TRUE).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)
.
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