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