The Excel AND Function

Related Function:
OR Function

Function Description

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

• TRUE if ALL of the conditions evaluate to TRUE
or
• FALSE otherwise (i.e. if ANY of the conditions evaluate to FALSE).

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.

Notes:

• In current versions of Excel (Excel 2007 and later), you can enter up to 255 logical_test arguments to the Excel And function. However, in Excel 2003, the function can only handle up to 30 arguments.
• If the logical_test arguments evaluate to numbers, instead of logical values, the value zero is treated as FALSE and all non-zero values are treated as TRUE.

Excel And Function Examples

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

Formulas:
ABC
1510=AND( A1>0, A1<B1 )
2510=AND( A2>0, A2<B2, B2>12 )
3510=AND( A3<0, A3>B3, B3>12 )
Results:
ABC
1510TRUE
2510FALSE
3510FALSE

Note that, in the above example spreadsheet:

• the function in cell C1 evaluates to TRUE, as BOTH of the supplied conditions are TRUE;
• the function in cell C2 evaluates to FALSE, as the third condition, B2>12, is FALSE;
• the function in cell C3 evaluates to FALSE, as ALL of the supplied conditions are FALSE.

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.