AND Command in Excel

 

What Does It Do?

This function tests two or more conditions to see if they are all true.

It can be used to test that a series of numbers meet certain conditions.

It can be used to test that a number or a date falls between an upper and lower limit.

Normally the AND() function would be used in conjunction with a function such as =IF().

Syntax

=AND(Test1,Test2)

Note that there can be up to 30 possible tests.

Formatting

When used by itself it will show TRUE or FALSE.

Example 1

The following example shows a list of examination results.

The teacher wants to find the pupils who scored above average in all three exams.

The =AND() function has been used to test that each score is above the average.

The result of TRUE is shown for pupils who have scored above average in all three exams.