← Back to level 2
Level 2Next
IFS
A medium decision formula that turns simple rules into automatic sheet logic.
Syntax
=IFS(...)Step-by-step explanation
- 1Write the condition that IFS should test first.
- 2Decide what should happen when the condition is true and when it is false.
- 3Enter the formula, then check that the result matches the scenario in the table.
Common mistakes
Missing commas or parentheses
Putting text in the wrong quotation marks
Over-nesting too many conditions
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=IFS(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =IFS(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use IFS to mark a score, status, or outcome in a realistic worksheet.
Match against the syntax block above.