Difference between revisions of "Manuals/calci/AND"
Jump to navigation
Jump to search
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size: | + | <div style="font-size:25px">'''AND(l1,l2...)'''</div><br/> |
| − | * | + | *<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( | + | *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 | + | *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 | + | *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 both the logical values are 1(TRUE), then AND value also should be 1 | + | *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}} | ||
==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 | + | *=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