IFS function in Google Sheets - Cheat Sheet & Quick Revision

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.

beginner

Write the basic syntax of the IFS function.

IFS(condition1, value_if_true1, condition2, value_if_true2, ..., conditionN, value_if_trueN)<br><br>Each condition is checked in order. The function returns the value for the first condition that is true.

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.

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.

beginner

Example: How to use IFS to assign grades based on scores?<br>Score in A1:<br>>=90: 'A'<br>>=80: 'B'<br>>=70: 'C'<br>else: 'F'

Use:<br>=IFS(A1>=90, "A", A1>=80, "B", A1>=70, "C", TRUE, "F")<br><br>This checks each score range and returns the correct grade.

What does the IFS function return if the first condition is TRUE?

A The value for the first condition

B The value for the last condition

C An error

D All values for all true conditions

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?

A IFS(condition1:value1, condition2:value2)

B IFS(value1, condition1, value2, condition2)

C IFS(condition1, value1, condition2, value2)

D IFS(condition1; value1; condition2; value2)

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?

A Nothing, IFS never errors

B A final condition TRUE with a default value

C A nested IF inside IFS

D A SUM function

Adding TRUE as the last condition acts like 'else' and prevents errors.

Which is a benefit of using IFS over nested IFs?

A Supports more conditions

B Runs faster on large data

C Automatically formats cells

D Cleaner and easier to read

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?

A IFS(A1>10, "Yes", TRUE, "No")

B IFS(A1>10, "No", TRUE, "Yes")

C IFS(TRUE, "Yes", A1>10, "No")

D IFS(A1>10, "Yes")

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.

Describe how to handle the case when none of the IFS conditions are true to avoid errors.

What acts like an 'else' in IFS?