Ravindra BagaleCourses & study guides Track your progress

Excel IFS Function

By · Last updated:

Chala mitrano — today IFS. Many questions in a line — Excel stops at the first YES and returns that answer.

Fictional sample data for learning. Grade bands for Coimbatore colleges and Berlin language schools. Mixed ₹ and €.

Purpose

Test several conditions in order and return the value for the first TRUE.

Return value

The matching value_if_true.

Syntax

IFS(logical_test1, value1, [logical_test2, value2], …)

Arguments

ArgumentRequired?Description
logical_test1RequiredFirst test.
value1RequiredResult if first test TRUE.
logical_test2, value2, …OptionalMore pairs in order.

Version

Excel 2019 / Microsoft 365. LibreOffice: use nested IF if IFS missing.

How to use — Why → What → How

Why: Grade bands and SLA colours need many branches without ugly nesting. Grade bands for Coimbatore colleges and Berlin language schools. Mixed ₹ and €. In Indian back offices and foreign sister teams, IFS shows up on approval, SLA and fee sheets every week.

What: IFS checks pairs top to bottom; first TRUE wins. Put a final TRUE,"Other" catch-all. Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Type =IFS(B2>=75,"A",B2>=60,"B",TRUE,"C").
  2. Order matters — highest band first.
  3. Add TRUE catch-all.

Ravindra Bagale's Tip

Friends, after IFS, find one IF/logic cell in a real workbook this week that this lesson improves.

Ravindra Bagale's Tip

Friends, sleep on IFS; rebuild example 1 tomorrow without looking.

Ravindra Bagale's Tip

Friends, say the business rule in plain words before =IFS.

Ravindra Bagale's Tip

Friends, after you finish IFS, open yesterday’s real workbook and find one place this function would have saved ten minutes.

Ravindra Bagale's Tip

Friends, treat IFS like a seatbelt on logic columns — use it before a manager asks why the flag is wrong.

Download practice file: practice-ifs.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) Grades

Coimbatore.

NameScore
Meera Iyer82
Formula: =IFS(B2>=75,"A",B2>=60,"B",B2>=35,"C",TRUE,"F")

Result: A

What it means: First true band.

2) Mid band

Score 65.

Score
65
Formula: =IFS(A2>=75,"A",A2>=60,"B",TRUE,"C")

Result: B

What it means: Second test wins.

3) Berlin € fee band

Fee.

Fee €
40
Formula: =IFS(A2>=100,"High",A2>=50,"Mid",TRUE,"Low")

Result: Low

What it means: Catch-all TRUE.

4) Status colours text

SLA.

Days
2
Formula: =IFS(A2<=1,"Green",A2<=3,"Amber",TRUE,"Red")

Result: Amber

What it means: Ordered thresholds.

5) No match without catch-all

Risk.

Score
10
Formula: =IFS(A2>=75,"A",A2>=60,"B")

Result: #N/A

What it means: Always add TRUE catch-all.

6) AND pair

City+score.

CityScore
Pune90
Formula: =IFS(AND(A2="Pune",B2>=80),"Star",TRUE,"Normal")

Result: Star

What it means: AND inside a test.

About this data. Small demo rows for learning. Real sheets are longer; the same formula pattern scales when columns are clean.

Common errors and fixes

#N/A — No test TRUE and no catch-all. Fix: Add TRUE,"Other".
#VALUE! — Odd pair count / bad tests. Fix: Pairs only.
Wrong band — Order wrong. Fix: Highest first.

Notes and tips

  • Revisit IFS errors after the quiz.
  • Build one example from memory.
  • Check types if results look wrong.
  • Teach a tip in Marathi or Hindi.
  • Keep currency consistent in one column (practice mixes ₹ $ £ €).
  • Drill: rebuild grade bands with a TRUE catch-all from memory.
  • IFS vs SWITCH: conditions vs exact expression matches.
  • Fictional sample data only.
  • Print the IFS revision card.
  • Ask juniors to predict before Enter.
  • Track your top mistake monthly.
  • Grade bands for Coimbatore colleges and Berlin language schools. Mixed ₹ and €.
  • Logical tests love TRIM and UPPER when text is messy.
  • Interview tip: explain the business rule before the formula.
  • When nesting, keep each IF on its own mental line — or switch to IFS/SWITCH.
  • Classroom drill: invent three brand-new formulas from your city without the page open.
  • Share one tip with a classmate — teaching locks the idea.
  • If a result looks wrong, check blanks vs zeros before rewriting logic.
  • Print the revision card for IFS for one week of real worksheets.
  • When helping a junior, ask them to predict before Enter.
  • Share one tip with a classmate in Marathi or Hindi.
  • Keep currency symbols consistent inside a single report column.
  • When Excel versions differ, write a nested-IF fallback under IFS/SWITCH in a comment.
  • Logical tests love TRIM and UPPER when text is messy.
  • Interview tip: explain the business rule before the formula.

In real work

Drill: rebuild grade bands with a TRUE catch-all from memory. Grade bands for Coimbatore colleges and Berlin language schools. Mixed ₹ and €. Classroom drill: write three brand-new IFS formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose and watch the error; recovering from that break is half of interview readiness. Always verify with a known case before trusting a long chain of logical tests. Keep a personal notebook of the one mistake you make most often with this function; review it monthly.

How it compares

IFS vs SWITCH: conditions vs exact expression matches.

Interview corner

Why catch-all?
Avoid #N/A.
Order?
Top test first.
Old Excel?
Nested IF.

IF, SWITCH, AND

Practice tasks (10)

  1. Task 1. A/B/C/F with IFS.
    Bands.
  2. Task 2. Show #N/A without catch-all.
    Risk.
  3. Task 3. Add TRUE catch-all.
    Fix.
  4. Task 4. SLA Green/Amber/Red.
    Days.
  5. Task 5. AND inside IFS.
    AND.
  6. Task 6. Explain order.
    Interview.
  7. Task 7. Fallback nested IF note.
    Version.
  8. Task 8. Fill grades.
    Fill.
  9. Task 9. Teach classmate.
    Teach.
  10. Task 10. Bonus: SWITCH for exact matches.
    Related.

Quick quiz

Q1. IFS picks:
Q2. Catch-all:
Q3. Older Excel without IFS:
Q4. No match error:
Q5. Order:

Answers: Q1=First TRUE, Q2=TRUE,"Other", Q3=Nested IF, Q4=#N/A, Q5=Critical (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: IFS
IFS revision card