AND Function

The AND function is one of the logical functions. It is used to check if the logical value you enter is TRUE or FALSE. The function returns TRUE if all the arguments are TRUE.

Syntax

AND(logical1, [logical2], ...)

The AND function has the following arguments:

Argument	Description
logical1/2/n	A condition that you want to check if it is TRUE or FALSE

Notes

How to apply the AND function.

The function returns FALSE if at least one of the arguments is FALSE.

Examples

There are three arguments: logical1 = A1<100, logical2 = 34<100, logical3 = 50<100, where A1 is 12. All these logical expressions are TRUE. So the function returns TRUE.

If we change the A1 value from 12 to 112, the function returns FALSE:

Return to previous page