Excel AND Function and Examples

The AND function in Excel is a logical function that evaluates multiple conditions simultaneously. It returns TRUE only when all specified conditions are satisfied. If even one condition fails, the result is FALSE. This function is often combined with others—such as IF, NOT, or OR—to build more advanced logical expressions.

How To Use AND Function in Excel?

The AND function is a key logical function in Excel that allows you to evaluate multiple conditions at once. It returns TRUE only when every condition provided is satisfied. If even one condition fails, the result will be FALSE. This function is especially useful when you need to ensure that a set of values all meet specific requirements before taking an action or performing a calculation. AND is frequently used in combination with other functions like IF, NOT, and OR to create more advanced logic tests. It’s a common choice for use inside IF statements, conditional formatting rules, and data validation setups. The AND function also helps simplify formulas by reducing the need for deeply nested IF statements.

The main role of the AND function is to verify multiple logical conditions and return TRUE only if all of them evaluate to TRUE. You can pass up to 255 separate conditions into the function, labeled as arguments like logical1, logical2, and so on. Each of these logical values must be TRUE for the overall result to be TRUE. The conditions themselves can be constants, references to cells, or logical expressions. If any one of them turns out FALSE, the AND function will return FALSE.

=AND(TRUE) // returns TRUE
=AND(TRUE,TRUE) // returns TRUE
=AND(TRUE,TRUE,TRUE) // returns TRUE
=AND(TRUE,TRUE,TRUE,TRUE) // returns TRUE
=AND(TRUE,TRUE,TRUE,TRUE,TRUE) // returns TRUE
...

If even one argument evaluates to FALSE, the AND function instantly returns FALSE.

=AND(FALSE) // returns FALSE
=AND(TRUE,FALSE) // returns FALSE
=AND(TRUE,FALSE,TRUE) // returns FALSE
=AND(TRUE,FALSE,TRUE,TRUE) // returns FALSE
=AND(TRUE,TRUE,TRUE,TRUE,FALSE) // returns FALSE
...

Keep in mind that the AND function treats numbers as logical values—any number other than zero is considered TRUE, while zero is treated as FALSE. You can observe this behavior in the examples below.

=AND(5,10) // returns TRUE and equals to AND(TRUE,TRUE)
=AND(5,10,0) // returns FALSE and equals to AND(TRUE,TRUE,FALSE)

Example 1: Single Value Greater Than 10:

To check whether a number is greater than 10, we can use the AND function. We can write a formula like the one below to return TRUE if the value in cell A2 is greater than 10, and FALSE otherwise.

Example 2: Both Numbers Greater Than 10:

Example 3: Number is Between Two Numbers:

AND Function Translations in Excel Languages