condition (Yes/No): At least 2 conditions are required.
Yes/No: TRUE if every condition is TRUE, otherwise FALSE.
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.