# 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

AND( logical_test1, [logical_test2], … )

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