Nested IF functions in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to check if a score in cell A1 is greater than 50.

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 '>' will reverse the logic.

Using '=' will only check if the score equals 50.

The formula checks if the value in A1 is greater than 50. If true, it returns "Pass", otherwise "Fail".

2fill in blank

medium

Complete the nested IF formula to assign grades: if score in B2 is greater than 80, return "A", else "B".

Google Sheets

=IF(B2 [1] 80, "A", "B")

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

A<=

B>

C<

D>=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<=' will give wrong grade assignments.

Using '>=' includes 80, but the task says strictly greater than.

The formula checks if the score in B2 is greater than 80. If yes, it returns "A", otherwise "B".

3fill in blank

hard

Fix the error in this nested IF formula to assign "High", "Medium", or "Low" based on value in C3.

Google Sheets

=IF(C3 > 70, "High", IF(C3 [1] 40, "Medium", "Low"))

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

A>

B<

C>=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' or '<=' in the second IF causes wrong logic.

Using '>' excludes 40, which may be incorrect.

The second IF checks if C3 is greater than or equal to 40 to assign "Medium"; otherwise, it assigns "Low".

4fill in blank

hard

Fill both blanks to complete the nested IF formula that assigns "Excellent", "Good", or "Needs Improvement" based on D4.

Google Sheets

=IF(D4 [1] 90, "Excellent", IF(D4 [2] 60, "Good", "Needs Improvement"))

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>=' excludes 90 from "Excellent".

Using '<=' instead of '>' includes 60 in "Needs Improvement".

The first condition checks if D4 is greater than or equal to 90 for "Excellent". The second checks if D4 is greater than 60 for "Good"; otherwise, "Needs Improvement".

5fill in blank

hard

Fill all three blanks to complete the nested IF formula that assigns "Pass", "Retake", or "Fail" based on E5.

Google Sheets

=IF(E5 [1] 70, "Pass", IF(E5 [2] 50, "Retake", IF(E5 [3] 30, "Fail", "Check")))

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>=' in the second blank excludes 50 from "Retake".

Using '>=' instead of '<' in the third blank causes wrong logic.

The formula checks if E5 is greater than or equal to 70 for "Pass". Then if E5 is greater than or equal to 50 for "Retake". Then if E5 is less than 30 for "Fail". Otherwise, it returns "Check".