0
0
Excelspreadsheet~10 mins

OR function in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data shows TRUE or FALSE values in cells A1 to A3 and B1 to B3 to test the OR function.

CellValue
A1
A2
A3
B1
B2
B3
Formula Trace
=OR(A1, A2, B3)
Step 1: OR(TRUE, FALSE, FALSE)
Cell Reference Map
TRUE
↓
FALSE
↓
FALSE
The formula uses values from cells A1, A2, and B3 to evaluate the OR function.
Result
TRUE
↓
FALSE
↓
FALSE
The formula result TRUE appears in cell C1 because at least one referenced cell (A1) is TRUE.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the OR function return if all arguments are FALSE?
ATRUE
BFALSE
CError
D0
Key Result
OR returns TRUE if any argument is TRUE; otherwise, it returns FALSE.