Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

AND function


AND(condition1,condition2,...) returns 1 (=TRUE) of all of its arguments are TRUE.

If one of the arguments, either condition1, condition2, etc. is FALSE (=0), the function returns 0 (=FALSE).

If one of the conditions cannot be evaluated (for example because of missing data), the function returns an error.


If GROUP and TREATMENT are variables defined in the spreadsheet then:

AND(GROUP=1,TREATMENT="B") returns 1 (=TRUE) if the case belongs to group 1 and received the treatment coded as "B" in the spreadsheet.

AND function


AND(  ,  

Related functions