IF function in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to return "Pass" if the score in cell A1 is 50 or more, otherwise "Fail".

Google Sheets

=IF(A1 [1] 50, "Pass", "Fail")

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

A=

B<

C>=

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>=' causes the logic to be reversed.

Using '=' only checks for exactly 50, not more.

The IF function checks if the value in A1 is greater than or equal to 50. If true, it returns "Pass"; otherwise, "Fail".

2fill in blank

medium

Complete the formula to return "Yes" if cell B2 contains the text "Complete", otherwise "No".

Google Sheets

=IF(B2 [1] "Complete", "Yes", "No")

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

A<>

B=

C<

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' checks for not equal, which reverses the logic.

Using '>' or '<' does not work for text equality.

The IF function checks if B2 is exactly equal to "Complete". If yes, it returns "Yes"; otherwise, "No".

3fill in blank

hard

Fix the error in the formula to return "High" if C3 is greater than 100, else "Low".

Google Sheets

=IF(C3 [1] 100, "High", "Low")

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

A>

B<

C<=

D==

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' causes a formula error.

Using '<' or '<=' reverses the condition.

The correct operator to check if C3 is greater than 100 is '>'. Using '==' causes an error in Google Sheets.

4fill in blank

hard

Fill both blanks to create a formula that returns "Adult" if age in D4 is 18 or more, otherwise "Minor".

Google Sheets

=IF(D4 [1] 18, [2], "Minor")

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

A>=

B"Adult"

CMinor

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' in the first blank reverses the logic.

Putting "Minor" in the second blank causes wrong output.

The formula checks if D4 is greater than or equal to 18. If true, it returns "Adult"; otherwise, "Minor".

5fill in blank

hard

Fill all three blanks to create a formula that returns the uppercase name if E5 is not empty, otherwise "No Name".

Google Sheets

=IF(E5 [1] "", [2](E5), [3])

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

A<>

BUPPER

C"No Name"

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' in the first blank checks if E5 is empty, reversing logic.

Using LOWER instead of UPPER changes the output.

Not putting quotes around "No Name" causes an error.

The formula checks if E5 is not empty (using '<>'). If true, it converts E5 to uppercase with UPPER(). Otherwise, it returns "No Name".