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
1.1 Syntax: =OR(A1>100)
1.2 Syntax: =OR(A1=150, A2=”Nokia”)
1.3 Syntax: =OR(A1<150, A2=”Nokia”)