Syntax

AND(condition1, condition2...)

Arguments

condition (Yes/No): At least 2 conditions are required.

Return Value

Yes/No: TRUE if every condition is TRUE, otherwise FALSE.

Examples

AND(FALSE, FALSE) : FALSE

AND(FALSE, TRUE) : FALSE

AND(TRUE, FALSE) : FALSE

AND(TRUE, TRUE) : TRUE

AND(ISNOTBLANK([Grade]), ([Grade] = "A")) : TRUE only if the Grade column value is both present and has a value of exactly A; otherwise FALSE.

AND(([Name] = "Acme"), ([Rating] > 3), [Preferred?]) : TRUE only if the row is for the company named Acme that has a rating of 3 or higher and is a preferred vendor; FALSE otherwise.

See Also

NOT(), OR()

Did this answer your question?