Difference between revisions of "Manuals/calci/AND"

Revision as of 04:58, 29 November 2013

AND(L1, L2 ...)

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

@@ Line 15: / Line 15: @@
 ==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 L1,L2 are not a logical  values
+*=AND(a+b=c,d+e=f)=NAN, because L1,L2 are not a logical  values
-A1= 70
-*AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125
+*Let A1= 70, =AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125
+==See Also==
+*[[Manuals/calci/NOT | NOT]]
+*[[Manuals/calci/OR  | OR]]
+*[[Manuals/calci/TRUE | TRUE]]
+*[[Manuals/calci/FALSE | FALSE]]
+==References==
+*[http://en.wikipedia.org/wiki/Bitwise_operation Bitwise Operation]
-AND (L)
-=AND (1,1) is 1 ie, TRUE and =AND(1,0) is 0. ie, FALSE
-B
-=AND(1&lt;B3,B3&lt;100) is 1(TRUE)
-=IF(AND(1&lt;B4,B4&lt;100, B4, "The value is out of range.") is out of range