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