Cross-column conditional rules in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to check if the value in column A is greater than 10.

Google Sheets

=IF(A2 [1] 10, "Yes", "No")

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

A<=

B<

C=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' will check if the value is less than 10.

Using '=' will check if the value equals 10, not greater.

The formula checks if the value in cell A2 is greater than 10. The correct operator is >.

2fill in blank

medium

Complete the formula to check if the value in column B is equal to the value in column C.

Google Sheets

=IF(B2 [1] C2, "Match", "No Match")

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

A<>

B=

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' checks for inequality, which is the opposite.

Using '>' or '<' checks for greater or less, not equality.

The formula compares if B2 equals C2. The correct operator is =.

3fill in blank

hard

Fix the error in the formula to check if the value in column D is less than or equal to 100.

Google Sheets

=IF(D2 [1] 100, "OK", "Check")

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

A<=

B>=

C<

D==

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' causes a syntax error in Google Sheets.

Using '<' only checks for less than, not equal.

The correct operator for 'less than or equal to' is <=. The operator '==' is not valid in Google Sheets formulas.

4fill in blank

hard

Fill both blanks to create a formula that checks if the value in column E is between 50 and 100 (inclusive).

Google Sheets

=IF(AND(E2 [1] 50, E2 [2] 100), "Valid", "Invalid")

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '<=' excludes 100 from the valid range.

Using '>' instead of '>=' excludes 50 from the valid range.

The formula checks if E2 is greater than or equal to 50 and less than or equal to 100. So the first operator is >= and the second is <=.

5fill in blank

hard

Fill all three blanks to create a formula that returns "Pass" if the value in column F is greater than 70 and the value in column G is less than 50, otherwise "Fail".

Google Sheets

=IF(AND(F2 [1] 70, G2 [2] 50), "[3]", "Fail")

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

A>

B<

CPass

D>=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>=' instead of '>' changes the condition slightly.

Returning 'Fail' in the true case instead of 'Pass'.

The formula checks if F2 is greater than 70 and G2 is less than 50. If both are true, it returns "Pass". So the first operator is >, the second is <, and the text to return is Pass.