Excel FunctionsLesson 101Free preview

OR

This lesson is part of Excel · All levels

Summary

OR is an Excel logic function that returns TRUE if at least one of the tested conditions is true. The syntax is. This function is often combined with IF to create an alternative condition.

Key points

OR yields TRUE if at least one condition is correct
OR only produces FALSE if all conditions are wrong
Accepting several logical arguments at once
Unlike AND, which requires all conditions to be correct.

Full lesson

Code examples and quizzes

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