OR Function

Summary

The Excel OR function returns TRUE when at least one logical test is TRUE. It returns FALSE only when every test is FALSE.

OR is useful when a formula should pass if any one condition is met. Common examples include qualification checks, alert rules, out-of-range tests, and flexible approval logic where there can be more than one valid path.

OR is useful when one successful condition is enough. It helps the workbook stay readable in rules where multiple acceptable paths exist, such as status checks, category matches, or validation formulas that allow more than one correct outcome.

Syntax

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

Microsoft documents that OR accepts from 1 to 255 logical conditions. Each argument should evaluate to TRUE or FALSE.

Arguments

• logical1 - [required] The first logical test.
• logical2... - [optional] Additional logical tests.

These arguments can be direct logical values, comparisons such as A1>10, or references that already contain TRUE or FALSE.

OR vs Other Logical Functions

OR is one of the main building blocks for flexible decision rules.

If your rule says "any one of these is enough," OR is usually the right function. If your rule says "all of these must happen," that is usually an AND formula instead.

Using OR

OR is often used inside IF when a model needs multiple success paths. For example, a record may qualify if it meets score A or score B, or an alert may trigger if any one sensor reports an error. OR keeps that kind of logic much clearer than stacking many nested IF statements.

OR is also useful for boundary checks. If a number should stay inside a safe range, OR can test the opposite condition by checking whether the value is below the lower limit or above the upper limit. That makes it a common choice for validation and alert formulas.

Microsoft notes that if an array or reference argument contains text or empty cells, those values are ignored. But if the specified range contains no logical values at all, OR returns #VALUE!. That mainly matters when you use OR on wider ranges or mixed data.

Example 1 - Pass If Either Score Is High Enough

This example returns TRUE when at least one of the two scores reaches the target.

=OR(B2>=70,C2>=70)

This is useful when a model allows more than one route to success instead of requiring every condition to pass.

Example 2 - Check Whether a Value Is Outside a Safe Range

OR is a clear way to detect when a number falls outside allowed limits.

=OR(B2<10,B2>20)

This returns TRUE when the value is too low or too high. It is a common validation pattern for stock levels, measurements, and threshold checks.

Example 3 - Trigger an Alert If Any Item Fails

Some warnings should appear as soon as one item in a group fails.

=OR(B2="Error",C2="Error",D2="Error")

This returns TRUE if any one of the listed cells contains "Error". It works well for alert flags and review checks.

Example 4 - Compare One Result Against Multiple Targets

OR can also compare a result against more than one benchmark.

=OR(B2>=G2,B2>=H2)

This returns TRUE when the result meets either target. It is useful when the workbook allows alternative thresholds or fallback goals.

Conclusion Recap

OR is for rules where one passing condition is enough. In this lesson, that included either score passing, values outside a range, any error flag, and either target being met.

If at least one test is TRUE, OR returns TRUE. That makes it useful for flexible rules and warning checks.

• Summary: OR returns TRUE when at least one test is TRUE.
• Best use: It is ideal when one passing condition is enough.
• Common pattern: Out-of-range checks such as "below this or above that."
• Range behavior: Text and blanks inside array or reference arguments are ignored.
• Error note: If a referenced range contains no logical values, OR returns #VALUE!.
• Practical pairing: Combine OR with IF to turn logic into a label or decision.