Skip to content
Excel

OR function in Excel

Returns TRUE if any argument is TRUE

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

OR syntax and parameters

Two arguments, one required.

  • logical1booleanRequired

    Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.

  • logical2booleanRepeating

    Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.

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 Google Sheets

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 Excel gets this done.