ExcelFlux

OR function

TRUE if any argument is TRUE.

Logical

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Raise an alert if either condition holds.

A worked example from the workbook

RowAB
6First valueSecond value
7TRUETRUE
8TRUEFALSE
9FALSEFALSE
Record 1
=OR(A7,B7)

Expected resultTRUE

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=OR(2=3,3=3)
Turkish Excel · tr-TR
=YADA(2=3;3=3)

Expected result

TRUE

Worked examples

Raise an alert if either condition holds.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First value Second value
7 TRUE TRUE
8 TRUE FALSE
9 FALSE FALSE
Case Formula Expected result
Record 1 =OR(A7,B7) TRUE
Record 2 =OR(A8,B8) TRUE
Record 3 =OR(A9,B9) FALSE
Microsoft Excel reference