AND
Syntax: AND(Cond_1; Cond_2; … Cond_30)
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
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
