AND EXCEL FORMULA
EXCEL FORMULA  
Function Dictionary  Function Examples  Function Categories  
AND 


Items To Test  Result  
500  800  TRUE  =AND(C4>=100,D4>=100)  
500  25  FALSE  =AND(C5>=100,D5>=100)  
25  500  FALSE  =AND(C6>=100,D6>=100)  
12  TRUE  =AND(D7>=1,D7<=52)  
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.  
Name  Maths  English  Physics  Passed  
Alan  80  75  85  TRUE  
Bob  50  30  40  FALSE  
Carol  60  70  50  FALSE  
David  90  85  95  TRUE  
Eric  20  30  Absent  FALSE  
Fred  40  60  80  FALSE  
Gail  10  90  80  FALSE  
Harry  80  70  60  TRUE  
Ian  30  10  20  FALSE  
Janice  10  20  30  FALSE  
=AND(C38>=AVERAGE($C$29:$C$38),D38> =AVERAGE($D$29:$D$38),E38>=AVERAGE ($E$29:$E$38)) 

Averages  47  54  60  