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.

Practice

1. What does the Excel formula =IF(A1>10, "Yes", "No") do?

easy

A. It checks if the value in A1 is greater than 10 and returns "Yes" if true, otherwise "No".

B. It adds 10 to the value in A1 and returns "Yes" or "No".

C. It always returns "Yes" regardless of A1's value.

D. It checks if A1 equals 10 and returns "Yes" or "No".

Solution

1. Step 1: Understand the IF function structure

   The IF function checks a condition first, here if A1>10.

2. Step 2: Determine the output based on the condition

   If the condition is true, it returns "Yes"; if false, it returns "No".

3. Final Answer:

   It checks if the value in A1 is greater than 10 and returns "Yes" if true, otherwise "No". -> Option A

4. Quick Check:

   IF(condition, true_result, false_result) = It checks if the value in A1 is greater than 10 and returns "Yes" if true, otherwise "No". [OK]

Hint: Remember: IF(condition, value_if_true, value_if_false) [OK]

Common Mistakes:

• Confusing the order of true and false results
• Thinking IF adds or changes values
• Assuming it always returns true result

2. Which of the following is the correct syntax for the IF function in Excel?

easy

A. =IF(condition; value_if_true; value_if_false)

B. =IF(condition value_if_true value_if_false)

C. =IF condition, value_if_true, value_if_false

D. =IF(condition, value_if_true, value_if_false)

Solution

1. Step 1: Recall Excel formula syntax

   Excel formulas use commas to separate arguments, not semicolons or spaces.

2. Step 2: Identify the correct syntax

   The correct syntax is =IF(condition, value_if_true, value_if_false).

3. Final Answer:

   =IF(condition, value_if_true, value_if_false) -> Option D

4. Quick Check:

   Arguments separated by commas = =IF(condition, value_if_true, value_if_false) [OK]

Hint: Use commas to separate IF arguments, not semicolons or spaces [OK]

Common Mistakes:

• Using semicolons instead of commas
• Omitting parentheses
• Not separating arguments properly

3. Given the formula =IF(B2<50, "Fail", "Pass") and the value in B2 is 45, what will be the result?

medium

A. Fail

B. Pass

C. 45

D. Error

Solution

1. Step 1: Evaluate the condition B2<50 with B2=45

   Since 45 is less than 50, the condition is true.

2. Step 2: Determine the IF function output

   Because the condition is true, the formula returns "Fail".

3. Final Answer:

   Fail -> Option A

4. Quick Check:

   Condition true returns first value = Fail [OK]

Hint: Check condition result first, then pick true or false output [OK]

Common Mistakes:

• Choosing the false result instead of true
• Returning the cell value instead of text
• Confusing less than and greater than

4. Identify the error in this formula: =IF(A1>100 "High" "Low")

medium

A. Wrong comparison operator

B. Missing commas between arguments

C. Extra parentheses

D. Incorrect use of quotes

Solution

1. Step 1: Check the IF function argument separators

   The formula lacks commas between the condition and the true/false results.

2. Step 2: Correct the formula syntax

   It should be =IF(A1>100, "High", "Low") with commas separating arguments.

3. Final Answer:

   Missing commas between arguments -> Option B

4. Quick Check:

   Arguments must be comma-separated = Missing commas between arguments [OK]

Hint: Always separate IF arguments with commas [OK]

Common Mistakes:

• Forgetting commas between arguments
• Using semicolons or spaces instead
• Misplacing quotes around text

5. You want to assign a grade based on score in cell C3: "A" if score is 90 or above, "B" if 80 to 89, and "F" otherwise. Which formula correctly uses nested IF functions?

hard

A. =IF(C3>90, "A", IF(C3>80, "B", "F"))

B. =IF(C3>=90, "A", IF(C3>=70, "B", "F"))

C. =IF(C3>=90, "A", IF(C3>=80, "B", "F"))

D. =IF(C3>=90, "A", IF(C3>80, "B", "F"))

Solution

1. Step 1: Understand the grading rules

   Score 90 or above = "A", 80 to 89 = "B", below 80 = "F".

2. Step 2: Check nested IF logic and conditions

   =IF(C3>=90, "A", IF(C3>=80, "B", "F")) correctly checks if C3≥90 for "A", else if C3≥80 for "B", else "F".

3. Final Answer:

   =IF(C3>=90, "A", IF(C3>=80, "B", "F")) -> Option C

4. Quick Check:

   Nested IF with correct ranges = =IF(C3>=90, "A", IF(C3>=80, "B", "F")) [OK]

Hint: Use nested IFs with descending conditions for ranges [OK]

Common Mistakes:

• Using > instead of ≥ causing wrong grade boundaries
• Incorrect second condition range
• Missing nested IF structure