Recall & Review
beginner
What is a Nested IF function in Google Sheets?
A Nested IF function is an IF formula placed inside another IF formula. It helps check multiple conditions one after another, like asking several questions in order.
Click to reveal answer
beginner
How does Google Sheets evaluate a Nested IF function?
Google Sheets checks the first IF condition. If it’s true, it returns the first result. If false, it moves to the next IF inside and checks that condition, repeating until it finds a true condition or reaches the last else result.
Click to reveal answer
beginner
Write a simple Nested IF formula to assign grades: If score ≥ 90, return "A", if ≥ 80 return "B", else "C".
The formula is: =IF(A1>=90, "A", IF(A1>=80, "B", "C"))
This checks if A1 is 90 or more, then 80 or more, else returns C.
This checks if A1 is 90 or more, then 80 or more, else returns C.
Click to reveal answer
intermediate
Why use Nested IF instead of multiple separate IFs?
Nested IFs let you check conditions in order inside one formula. This keeps your sheet tidy and your logic clear, instead of spreading checks across many cells.Click to reveal answer
beginner
What is a common mistake when writing Nested IF functions?
A common mistake is forgetting to close all parentheses or mixing the order of conditions, which can cause errors or wrong results.
Click to reveal answer
What does a Nested IF function do in Google Sheets?
✗ Incorrect
Nested IF functions check several conditions in order, returning results based on which condition is true first.
Which formula correctly uses Nested IF to return "Pass" if score ≥ 50, else "Fail"?
✗ Incorrect
The formula checks if A1 is 50 or more, then returns "Pass", else "Fail".
What happens if all conditions in a Nested IF are false and no else is provided?
✗ Incorrect
If no else result is given and all conditions are false, the formula returns FALSE.
How many IF functions can you nest in Google Sheets?
✗ Incorrect
Google Sheets allows nesting up to 64 IF functions inside each other.
Which is a good practice when writing Nested IF formulas?
✗ Incorrect
Writing conditions from most specific to general helps the formula work correctly and clearly.
Explain how a Nested IF function works in Google Sheets and give a simple example.
Think about asking questions one after another.
You got /4 concepts.
Describe common mistakes to avoid when creating Nested IF formulas.
Think about formula errors and logic mistakes.
You got /4 concepts.