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().
Note that there can be up to 30 possible tests.
When used by itself it will show TRUE or FALSE.
|Items To Test||Result|
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.
|=AND(C38>=AVERAGE($C$29:$C$38), D38>=AVERAGE($D$29:$D$38), E38>=AVERAGE($E$29:$E$38))|