Formula Library

OR

logical

Returns TRUE if any condition is true, FALSE only if all conditions are false.

Syntax

=OR(logical1, [logical2, ...])

Example

Excel
=OR(A2="Yes", A2="Maybe")

Returns TRUE if A2 is either "Yes" or "Maybe".

Tips & Notes

  • →Combine with IF for conditional logic
  • →OR(A1>10, B1>10) is equivalent to (A1>10)+(B1>10)>0 in array formulas
  • →Use with SUMPRODUCT for conditional counting

See Also

ANDIF

Need a custom OR formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.