The Excel AND Function

Home » Excel-Built-In-Functions » Excel-And-Function

Search this site:

Custom Search

Related Function :

OR Function

Basic Description

The Excel AND function tests a number of user-defined conditions and returns a result of:

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

The format of the And function is:

AND( Logical_test1, Logical_test2, ... )

where Logical_test1, Logical_test2, ... are user-defined conditions which return TRUE or FALSE.

Examples

The following examples show the AND function applied to a number of different conditions. The format of the functions are shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right

Formulas

	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 )

Results

	A	B	C
1	5	10	TRUE
2	5	10	FALSE
3	5	10	FALSE

In the examples above,

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