FormulaCraft

OR

OR returns TRUE if any of its conditions is true and FALSE only when all are false. Nest it in IF to act when at least one requirement is met.

Excel
=OR(A2>100, B2>100)
Google Sheets
=OR(A2>100, B2>100)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

XY
50150

=OR(A2>100, B2>100)→TRUE

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2>100 and B2>100 are the conditions.
  2. 2OR is TRUE if either one is true.
  3. 3B2 is 150, so the result is TRUE.

Need a version for your data?

Try: “Check whether either A2 or B2 is greater than 100”

Related

IFIFERRORIFS

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: