IFS function (multiple conditions) in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=IFS(A1 [1] 50, "Pass", TRUE, "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 wrong results.

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

The IFS function checks if the value in A1 is greater than or equal to 50 to return "Pass". Otherwise, it returns "Fail".

2fill in blank

medium

Complete the formula to return "Excellent" if score is 90 or more, "Good" if 70 or more, otherwise "Needs Improvement".

Excel

=IFS(A1 [1] 90, "Excellent", A1 [1] 70, "Good", TRUE, "Needs Improvement")

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

A<=

B<

C>=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using different operators for the two conditions causes errors.

Using '<' instead of '>=' reverses the logic.

The formula checks if A1 is at least 90 for "Excellent", then at least 70 for "Good". Otherwise, it returns "Needs Improvement".

3fill in blank

hard

Fix the error in the formula to correctly assign grades: "A" for 90+, "B" for 80+, "C" for 70+, else "F".

Excel

=IFS(A1 [1] 90, "A", A1 [1] 80, "B", A1 [1] 70, "C", TRUE, "F")

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

A>

B>=

C<

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<=' causes the formula to assign wrong grades.

Using '<' reverses the condition meaning.

Using '>=' ensures the formula checks if the score meets or exceeds each grade threshold correctly.

4fill in blank

hard

Fill both blanks to create a formula that returns "Low" if A1 is less than 50, "Medium" if between 50 and 80, else "High".

Excel

=IFS(A1 [1] 50, "Low", A1 [2] 80, "Medium", TRUE, "High")

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 reverses the logic.

Using '>' instead of '<=' in the second blank causes wrong results.

The first condition checks if A1 is less than 50 for "Low". The second checks if A1 is less than or equal to 80 for "Medium". Otherwise, it returns "High".

5fill in blank

hard

Fill all three blanks to create a formula that returns "Fail" if score < 50, "Pass" if score >= 50 and < 75, else "Distinction".

Excel

=IFS(A1 [1] 50, "Fail", AND(A1 [2] 50, A1 [3] 75), "Pass", TRUE, "Distinction")

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

A<

B>=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>=' in the first blank causes wrong fail condition.

Mixing up '<' and '>=' in the second and third blanks causes errors.

The formula checks if A1 is less than 50 for "Fail". Then if A1 is at least 50 and less than 75 for "Pass". Otherwise, it returns "Distinction".