Home › Functions › Logical › OR
fx
OR
Logical  ·  Since: Excel 2003  ·  9 languages

Use the OR function, one of the logical functions , to determine if any conditions in a test are TRUE.

🌐 Translations

English OR
Deutsch ODER
Français OU
Español O
Italiano O
Português OU
Nederlands OF
Polski LUB
Русский ИЛИ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

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

Arguments

logical1 (required) — The first condition that you want to test that can evaluate to either TRUE or FALSE.
logical2 (optional) — Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.

▶ Examples

=OR(A2>1,A2<100)

Related functions

Copied to clipboard