The Excel AND Function

Related Function:
OR Function

Function Description

The Excel AND function tests a number of supplied conditions and returns:


The syntax of the function is:

AND( logical_test1, [logical_test2], ... )

where the logical_test arguments are one or more conditions that evaluate to either TRUE or FALSE.


Excel And Function Examples

The following spreadsheet shows three examples of the Excel And function:

  A B C
1 5 10 =AND( A1>0, A1<B1 )
2 5 10 =AND( A2>0, A2<B2, B2>12 )
3 5 10 =AND( A3<0, A3>B3, B3>12 )
  A B C
1 5 10 TRUE
2 5 10 FALSE
3 5 10 FALSE

Note that, in the above example spreadsheet:

For further details of the Excel And function, see the Microsoft Office website.

Excel And Function Error

If you get an error from the Excel And Function, this is likely to be the #VALUE! error:

Common Error
#VALUE! - Occurs if any of the supplied logical_test arguments are text values.