How to Use Excel AND Function (Example + Video)

Excel AND Function (Example + Video)

Excel AND Function

When to use Excel AND Function

Excel AND function can be used when you want to check multiple conditions.

What it Returns

It returns TRUE if all the conditions evaluate to TRUE, else it returns a FALSE (Note: it would return FALSE even if one condition is FALSE).

Syntax

=AND(logical1, [logical2],…)

Input Arguments

  • logical1 – the first condition that you want to evaluate for TRUE or FALSE.
  • [logical2] – (Optional) This is the second condition that you want to evaluate for TRUE or FALSE.

Additional Notes

  • AND function can be used with other formulas to be more efficient.
    • For example, in an IF Function, you can test a condition and then specify a value when it’s TRUE and a value when it is FALSE. Using AND function within IF enables users to test multiple conditions at one go.
      • For example, if you have to test whether if A1 is greater than 0 and less than 100, here is how you can do it in an IF function:
        =IF(AND(A1>0,A1<100),”Approve”,”Reject”)
  • The arguments must either evaluate to logical values (TRUE/FALSE), or the arguments must be arrays/references of logical values.
  • Text and empty cells are ignored.
  • If the specified range contains no logical values, the AND function returns #VALUE! error.
  • You can test a maximum of 255 conditions in a single AND function.

Excel AND Function – Live Example

Excel AND Function – Video Tutorial

.

Related Excel Functions: