Skip to content
Google Sheets

OR function in Google Sheets

Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.

=OR(logical_expression1, [logical_expression2, ...])

OR syntax and parameters

Two arguments, one required.

  • logical_expression1booleanRequired

    An expression or reference to a cell containing an expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value.

  • logical_expression2booleanRepeating

    [ OPTIONAL ] - Additional expressions or references to cells containing expressions representing some logical values, i.e. TRUE or FALSE, or expressions that can be coerced to logical values.

OR examples

Formulas you'll actually reuse.

  1. Does the order belong to either of two regions?

    =OR(A2 = "West", A2 = "North")

    ResultTRUE

  2. Flag for manual review when either condition trips:

    =IF(OR(D2 > 5000, C2 = "Enterprise"), "Review", "Auto-approve")

    Result"Review"

OR in Excel

Same name — your formula ports as-is.

Try OR in the playground

Edit the example — nothing to install.

Preloaded with the OR formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.