How to use Excel AND Function

This Excel tutorial explains how to use the AND function with syntax and examples.

Excel AND Function Description

Microsoft Excel AND function tests a number of supplied conditions and returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.

That is;

• TRUE if ALL of the conditions evaluate to TRUE

or

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

Excel And Function Examples

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

Explanation:  Based on the example above, the AND function returns;

• 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.

Syntax

Arguments

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.