Difference between revisions of "Manuals/calci/AND"
Jump to navigation
Jump to search
(14 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 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 | |
− | If both the logical values are 1(TRUE), then AND value also should be 1 | ||
− | |||
+ | ==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 14:06, 7 June 2015
AND(l1,l2...)
- 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
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