IF function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=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 score 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 is empty, otherwise "No".

Excel

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

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

A>

B<

C<>

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' checks if B2 is not empty, which reverses the logic.

Using '>' or '<' does not work for checking empty strings.

The formula checks if B2 equals an empty string "". If yes, it returns "Yes"; otherwise, "No".

3fill in blank

hard

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

Excel

=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 in Excel.

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

The correct operator to check if C3 is greater than 100 is '>'. The operator '==' is not valid in Excel formulas.

4fill in blank

hard

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

Excel

=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 '<' reverses the condition.

Returning 'Minor' in the true part is incorrect.

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 four blanks to create a formula that returns the uppercase name if score in E5 is above 75, else returns the name as is.

Excel

=IF(E5 [1] 75, [2]([3]), [4])

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

A>

BUPPER

CF5

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<=' reverses the logic.

Not using UPPER function for uppercase conversion.

The formula checks if E5 is greater than 75. If true, it converts the name in F5 to uppercase using UPPER(F5). Otherwise, it returns the name as is from F5.