Recall & Review
beginner
What does the IFS function do in Google Sheets?
The IFS function checks multiple conditions one by one and returns a value for the first true condition. It helps avoid nested IF statements.
Click to reveal answer
beginner
Write the basic syntax of the IFS function.
IFS(condition1, value_if_true1, condition2, value_if_true2, ..., conditionN, value_if_trueN)
Each condition is checked in order. The function returns the value for the first condition that is true.
Each condition is checked in order. The function returns the value for the first condition that is true.
Click to reveal answer
intermediate
How does IFS differ from nested IF statements?
IFS is simpler and cleaner because it lists conditions and results in pairs without many parentheses. Nested IFs can be confusing with many layers.
Click to reveal answer
intermediate
What happens if none of the IFS conditions are true?
If no condition is true, IFS returns an #N/A error. To avoid this, add a final condition that is always TRUE with a default value.
Click to reveal answer
beginner
Example: How to use IFS to assign grades based on scores?
Score in A1:
>=90: 'A'
>=80: 'B'
>=70: 'C'
else: 'F'
Score in A1:
>=90: 'A'
>=80: 'B'
>=70: 'C'
else: 'F'
Use:
=IFS(A1>=90, "A", A1>=80, "B", A1>=70, "C", TRUE, "F")
This checks each score range and returns the correct grade.
=IFS(A1>=90, "A", A1>=80, "B", A1>=70, "C", TRUE, "F")
This checks each score range and returns the correct grade.
Click to reveal answer
What does the IFS function return if the first condition is TRUE?
✗ Incorrect
IFS returns the value corresponding to the first condition that is TRUE and stops checking further.
Which of these is the correct syntax for IFS?
✗ Incorrect
The correct syntax pairs each condition with its value separated by commas.
What should you add to IFS to avoid errors if no conditions are true?
✗ Incorrect
Adding TRUE as the last condition acts like 'else' and prevents errors.
Which is a benefit of using IFS over nested IFs?
✗ Incorrect
IFS is easier to write and read because it avoids deep nesting.
If you want to check if A1 is greater than 10 and return 'Yes', otherwise 'No', which formula is correct?
✗ Incorrect
This formula returns 'Yes' if A1>10, otherwise 'No' using the TRUE default.
Explain how the IFS function works and when you would use it instead of nested IF statements.
Think about checking many yes/no questions in order.
You got /4 concepts.
Describe how to handle the case when none of the IFS conditions are true to avoid errors.
What acts like an 'else' in IFS?
You got /3 concepts.