0
0
Google Sheetsspreadsheet~10 mins

AND and OR functions in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data shows TRUE and FALSE values in cells A1 to A3 and B1 to B3 to test AND and OR functions.

CellValue
A1TRUE
A2FALSE
A3TRUE
B1FALSE
B2TRUE
B3TRUE
Formula Trace
=AND(A1, A2, B2)
Step 1: AND(TRUE, FALSE, TRUE)
Cell Reference Map
TRUE
↓
FALSE
↓
TRUE
Formula references cells A1, A2, and B2 which contain TRUE, FALSE, and TRUE respectively.
Result
TRUE
↓
FALSE
↓
TRUE
The formula =AND(A1, A2, B2) placed in C1 returns FALSE because not all inputs are TRUE.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =AND(A1, A3, B3) return given the sample data?
AFALSE
BTRUE
CError
D0
Key Result
AND returns TRUE only if all arguments are TRUE; OR returns TRUE if any argument is TRUE.