AND and OR functions in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to check if both A1 and B1 are TRUE using the AND function.

Google Sheets

=AND([1])

Drag options to blanks, or click blank then click option'

AA1-B1

BA1 B1

CA1+B1

DA1, B1

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting commas between arguments

Using spaces instead of commas

Trying to add or subtract logical values

The AND function takes multiple logical values separated by commas. So, AND(A1, B1) checks if both are TRUE.

2fill in blank

medium

Complete the formula to check if either A1 or B1 is TRUE using the OR function.

Google Sheets

=OR([1])

Drag options to blanks, or click blank then click option'

AA1 B1

BA1+B1

CA1, B1

DA1-B1

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces instead of commas

Adding or subtracting logical values

Leaving out one argument

The OR function checks if at least one argument is TRUE. Arguments must be separated by commas, like OR(A1, B1).

3fill in blank

hard

Fix the error in this formula that checks if both A2 and B2 are TRUE: =AND(A2 B2)

Google Sheets

=AND([1])

Drag options to blanks, or click blank then click option'

AA2, B2

BA2 B2

CA2+B2

DA2-B2

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving out commas between arguments

Using spaces instead of commas

The error is missing commas between arguments. Correct is AND(A2, B2).

4fill in blank

hard

Fill both blanks to create a formula that returns TRUE if A3 is TRUE and either B3 or C3 is TRUE.

Google Sheets

=AND(A3, OR([1], [2]))

Drag options to blanks, or click blank then click option'

AB3

BC3

CA3

DB2

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong cell references

Putting A3 inside OR instead of AND

Using cells not related to the condition

The formula uses AND to check A3 is TRUE and OR to check if either B3 or C3 is TRUE. So, OR(B3, C3) fits inside AND.

5fill in blank

hard

Fill all three blanks to create a formula that returns TRUE if either A4 is TRUE or both B4 and C4 are TRUE.

Google Sheets

=OR(A4, AND([1], [2]), [3])

Drag options to blanks, or click blank then click option'

AB4

BC4

CA4

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Using A4 inside AND instead of OR

Leaving the third argument blank

Using unrelated cells

The formula checks if A4 is TRUE or both B4 and C4 are TRUE. The AND part uses B4 and C4. The last argument is FALSE to complete the OR function without extra conditions.