Manuals/calci/AND

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
• If 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

• Let A1= 70, =AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125

See Also

• NOT
• OR
• TRUE
• FALSE

References

• Bitwise Operation