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...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''AND(L1, L2 ...)'''</div><br/> |
| + | |||
| + | *L1,L2... 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 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 and either of the logical value is 0(FALSE), then the AND value is 0 | ||
| + | |||
| + | |||
| + | |||
| + | ==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 | ||
| + | 70 | ||
| + | 150 | ||
| + | AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125 | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
AND (L) | AND (L) | ||
| − | + | =AND (1,1) is 1 ie, TRUE and =AND(1,0) is 0. ie, FALSE | |
B | B | ||
| Line 29: | Line 53: | ||
110 | 110 | ||
| − | + | =AND(1<B3,B3<100) is 1(TRUE) | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | =IF(AND(1<B4,B4<100, B4, "The value is out of range.") is out of range | |
| − | |||
Revision as of 04:20, 29 November 2013
AND(L1, L2 ...)
- L1,L2... 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 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 and either of the logical value is 0(FALSE), then the AND value is 0
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 70 150 AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125
AND (L)
=AND (1,1) is 1 ie, TRUE and =AND(1,0) is 0. ie, FALSE
B
55
110
=AND(1<B3,B3<100) is 1(TRUE)
=IF(AND(1<B4,B4<100, B4, "The value is out of range.") is out of range