How to Use IFS in Excel
IFS checks multiple conditions in order and returns the first matching result. Here's the syntax, a realistic status example, and the mistakes that cause the wrong label to appear.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
IFS is Excel's cleaner alternative to stacking nested IF statements when you need multiple possible outcomes. Use it when one condition is not enough and the formula needs to test several rules in sequence.
That makes it useful for status labels, grading bands, review flags, approval logic, and any other sheet where one row can fall into several categories.
The syntax
=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)- logical_test1 — the first condition Excel should check
- value_if_true1 — what to return if that condition is true
- Add more test/result pairs for additional branches
IFS returns the value from the first condition that evaluates to true.
Basic example
If D2 contains days until a deadline, you could classify the row like this:
=IFS(D2<0, "Late", D2=0, "Due today", D2<=3, "Due soon", D2>3, "On track")Excel checks each condition from left to right and stops at the first match.
That is why order matters.
Step-by-step project status example
Say C2 contains percent complete and D2 contains days until due date.
You want to label the work item as:
Blockedif percent complete is 0 and the due date has passedAt riskif the due date is within 3 days and progress is under 80%On trackif progress is at least 80%In progressfor everything else
One way to write that is:
=IFS(AND(C2=0,D2<0), "Blocked", AND(D2<=3,C2<0.8), "At risk", C2>=0.8, "On track", TRUE, "In progress")Step 1. Put the highest-priority condition first.
Step 2. Put more general conditions later.
Step 3. Use TRUE as the final catch-all when you need a default result.
That pattern works well in a project tracker template, OKR tracker, or any execution sheet that needs consistent labels.
IFS vs nested IF
Nested IF works, but it gets hard to read fast:
=IF(D2<0, "Late", IF(D2=0, "Due today", IF(D2<=3, "Due soon", "On track")))IFS expresses the same branching logic more directly:
=IFS(D2<0, "Late", D2=0, "Due today", D2<=3, "Due soon", TRUE, "On track")The main advantage is readability, especially once the formula grows beyond two branches.
Common mistakes with IFS
| Mistake | What happens | Fix |
|---|---|---|
| Putting broad logic first | Specific cases never fire | Order the most restrictive or highest-priority tests first |
| Forgetting a fallback | Excel returns #N/A when nothing matches | End with TRUE, "Default" if you need a catch-all |
| Mixing percent values and whole numbers | Labels are wrong | Be consistent: 0.8 means 80% when the cell stores a true percentage |
| Using IFS for only two outcomes | Formula is longer than needed | Use plain IF when there are only two branches |
⚠ WATCH OUT
IFS does not keep checking once it finds a true condition. If an early test is too broad, the rest of the formula becomes irrelevant.
When to use IFS
IFS is strongest when the sheet needs more than a yes/no answer. Common uses:
- turning dates into urgency labels
- assigning score bands or performance tiers
- mapping project health into status text
- classifying rows before a dashboard or filtered view
If the workbook only needs one binary outcome, standard IF is usually better.
The Griddy way
IFS formulas often break because the condition order is wrong, the fallback is missing, or the logic mixes text, numbers, and percentages in inconsistent ways.
"Label each task as Blocked, At risk, On track, or In progress based on percent complete and days until due date"
Griddy can write the IFS formula in the right order and fit it to the actual columns in your sheet.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Apply branching logic to status-heavy trackers
IFS is useful when project and operations sheets need clean labels for urgency, health, or workflow status based on multiple conditions.
Project Tracker
Track tasks, owners, priorities, due dates, and blockers in one delivery board. Group work by stream, review progress, and keep next steps visible.
Project Tracker for Marketing Teams
Track campaign work, owners, deadlines, approvals, and blockers in one free marketing project tracker spreadsheet for Excel and Google Sheets.
Project Tracker for Client Work
Track client deliverables, owners, due dates, approvals, and blockers in one free project tracker spreadsheet built for service teams.
OKR Tracker
Track company and team OKRs in one quarterly scorecard. Keep objective scores, KR progress, and leadership notes visible without needing dedicated OKR software.
OKR Tracker for Startups
Track startup objectives, key results, owners, progress, and confidence in one free OKR spreadsheet built for quarterly planning and review.
Employee Schedule
Plan a weekly staff rota with day-by-day shifts, weekly hours, overtime flags, and a manager snapshot block. Free template for teams, shops, and clinics.