Nested IF functions in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to check if A1 is greater than 10.

Excel

=IF(A1 [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 > causes the formula to check the wrong condition.

Using = will check if A1 equals 10, not greater than 10.

The formula checks if the value in cell A1 is greater than 10 using the > operator.

2fill in blank

medium

Complete the nested IF formula to return "High" if B1 > 80, else "Low".

Excel

=IF(B1 [1] 80, "High", "Low")

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

A<=

B<

C>=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using < instead of > reverses the logic.

Using <= or >= changes the condition to include equality.

The formula returns "High" if the value in B1 is greater than 80, otherwise "Low".

3fill in blank

hard

Fix the error in the nested IF formula to check if C1 is between 50 and 100.

Excel

=IF(C1 [1] 50, IF(C1 [2] 100, "Yes", "No"), "No")

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

A>=

B<=

C<

D>

Attempts:

3 left

💡 Hint

Common Mistakes

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

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

The formula checks if C1 is greater than or equal to 50 and less than or equal to 100 using >= and <= operators.

4fill in blank

hard

Fill both blanks to create a nested IF that returns "Pass" if D1 >= 60, "Fail" otherwise.

Excel

=IF(D1 [1] 60, "Pass", IF(D1 [2] 60, "Fail", "Fail"))

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

A>=

B<=

C<

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using <= in the first blank would include 59 as passing.

Using > in the second blank would cause logic errors.

The first blank uses >= to check if D1 is at least 60. The second blank uses < to check if D1 is less than 60, returning "Fail" in both other cases.

5fill in blank

hard

Fill all three blanks to create a nested IF that returns "Excellent" if E1 > 90, "Good" if E1 > 75, else "Needs Improvement".

Excel

=IF(E1 [1] 90, "Excellent", IF(E1 [2] 75, "Good", "[3]"))

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

A>

CNeeds Improvement

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using <= instead of > in the first blank would invert the logic.

Forgetting to put the else text in the third blank.

The first blank uses > to check if E1 is greater than 90. The second blank uses > to check if E1 is greater than 75. The third blank fills the else text "Needs Improvement".