Challenge - 5 Problems
Nested IF Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
📊 Formula Result
intermediate2:00remaining
Output of Nested IF for Grade Evaluation
Given the formula
=IF(A1>=90, "A", IF(A1>=80, "B", IF(A1>=70, "C", "F"))) in cell B1, what will be the output if A1 contains the value 85?Attempts:
2 left
💡 Hint
Think about the conditions checked in order from highest to lowest.
✗ Incorrect
The formula checks if A1 is 90 or more for "A". Since 85 is less than 90 but greater than or equal to 80, it returns "B".
📊 Formula Result
intermediate2:00remaining
Nested IF Output for Discount Calculation
What is the result of the formula
=IF(B2>1000, "20%", IF(B2>500, "10%", "0%")) if cell B2 contains 500?Attempts:
2 left
💡 Hint
Check each condition carefully and remember the order matters.
✗ Incorrect
Since 500 is not greater than 1000 and not greater than 500 (it's equal), both conditions fail, so the formula returns "0%".
❓ Function Choice
advanced2:00remaining
Choosing the Correct Nested IF for Age Group
Which formula correctly assigns age groups as follows: "Child" if age < 13, "Teen" if age is between 13 and 19 inclusive, and "Adult" if age is 20 or more? Assume age is in cell A1.
Attempts:
2 left
💡 Hint
Check the boundary conditions carefully for each age group.
✗ Incorrect
Option B correctly uses <13 for Child, <=19 for Teen (which includes 19), and Adult otherwise. Other options misplace boundaries.
🎯 Scenario
advanced2:00remaining
Nested IF for Multi-level Commission Rates
You want to calculate commission based on sales in cell C1: 5% if sales < 1000, 10% if sales between 1000 and 4999, 15% if sales between 5000 and 9999, and 20% if sales 10000 or more. Which formula correctly calculates the commission rate as a decimal (e.g., 0.05 for 5%)?
Attempts:
2 left
💡 Hint
Remember to use less than for upper bounds to avoid overlap.
✗ Incorrect
Option A correctly uses < for upper bounds to avoid overlapping ranges and matches the problem's ranges exactly.
❓ data_analysis
expert2:00remaining
Count of Cells Returning "Pass" in Nested IF Formula
You have a column A with scores from 0 to 100. The formula
=IF(A1>=60, "Pass", "Fail") is applied down column B for 100 rows. How many cells in column B will show "Pass" if the scores in column A are all integers from 0 to 99?Attempts:
2 left
💡 Hint
Count how many numbers from 0 to 99 are 60 or greater.
✗ Incorrect
Scores from 60 to 99 inclusive are 40 numbers, but since 0 to 99 is 100 numbers total, count is 40. However, 60 to 99 is 40 numbers, so answer is 40.