September 2011
Beginner
140 pages
3h 40m
English
This function is used to compare results of up to 30 (thirty) conditions. The value of AND is TRUE if all of the conditions tested are TRUE as well. For example, the following formula is TRUE only if A1 is equal to A2 and A3, otherwise, it is FALSE:
=AND(A1=A2; A2=A3)
Figure 13-4. Sample results of the AND function
Read now
Unlock full access