How to use the Excel OR function

In contrast to AND, OR returns the true value if any of the conditions is satisfied and returns false if all conditions are not met.

Syntax: =OR( condition1, [condition2, … condition_n] )

The OR function syntax has the following arguments:

  • condition1: A condition to test that can either be TRUE or FALSE.
  • condition2, … condition_n (Optional) Conditions to test that can either be TRUE or FALSE. There can be up to 30 conditions.

Example: Table of values

excel or - How to use the Excel OR function

1.1 Syntax: =OR(A1>100) 

Result:

or excel - How to use the Excel OR function

1.2 Syntax: =OR(A1=150, A2=”Nokia”)

Result:

Excel OR function - How to use the Excel OR function

1.3 Syntax: =OR(A1<150, A2=”Nokia”)

Result:

OR function - How to use the Excel OR function

Add a Comment

Your email address will not be published. Required fields are marked *