Articles with the tag:
Articles with the tag:
Try in the cloud
Try in the cloud

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.


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


How to apply the AND function.

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


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.

AND Function: TRUE

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

AND Function: FALSE

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action