Excel FunctionsLesson 72Free preview

AND

This lesson is part of Excel · All levels

Summary

The AND function returns TRUE only if the given entire condition is TRUE. You can compare multiple cells at once, like a value above 60 and a full presence. AND is often combined with IF to determine whether or not a graduation status is based on more than one condition.

Key points

AND produces TRUE when all conditions are met
Accept some of the conditioning arguments separated by the comma
It's only when there's one failed condition.
Often combined with IF: =IF(AND(...), ...)

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.