Cellwise

Logic function

Excel IFS function

IFS checks a list of conditions in order and returns the value paired with the first one that is TRUE. It is a cleaner way to write grade bands, shipping tiers, or commission rates than stacking IFs inside each other.

fx=IFS(test1, value1, [test2, value2], ...)

Arguments

test1
The first condition to check.
value1
What to return if test1 is TRUE.
test2, value2
More condition and result pairs, checked in order. You can add up to 127 pairs.

IFS examples

Every result below was calculated live from this sample sheet.

ABC
1OrderTotalRegion
2SO-2041245West
3SO-204238.5East
4SO-20431120West
5SO-204496South
  1. fx=IFS(B2>=1000,"Gold",B2>=200,"Silver",B2>=50,"Bronze")

    Result: Silver

    A $245 order skips the Gold test and matches Silver.

  2. fx=IFS(B4>=1000,"Gold",B4>=200,"Silver",B4>=50,"Bronze")

    Result: Gold

    The $1,120 order matches the first test, so it is Gold.

  3. fx=IFS(B3>=1000,"Gold",B3>=200,"Silver",B3>=50,"Bronze")

    Result: #N/A

    No test is true for $38.50, so IFS returns #N/A.

  4. fx=IFS(B3>=1000,"Gold",B3>=200,"Silver",B3>=50,"Bronze",TRUE,"Standard")

    Result: Standard

    End with TRUE as a catch-all so every order gets a label.

How to use IFS

  1. Click the cell for the result.
  2. Type =IFS( and the first condition, then a comma and its result.
  3. Add more condition and result pairs, most restrictive first.
  4. Finish with TRUE and a default value, then close the bracket.

Common IFS mistakes

No default at the end

If nothing matches, IFS returns #N/A. Add TRUE,"Other" as the last pair.

Conditions in the wrong order

IFS stops at the first TRUE. Put B2>=1000 before B2>=200, or everything big lands in the smaller band.

An unpaired argument

Every test needs a value. An odd number of arguments makes Excel refuse the formula.

IFS FAQ

What is the difference between IF and IFS in Excel?

IF tests one condition and has a false branch. IFS tests many conditions in a flat list but has no else branch, so you add TRUE as the last test instead.

How do I add an else to IFS in Excel?

Use TRUE as the final test: =IFS(A2>90,"A",A2>80,"B",TRUE,"C"). TRUE always matches, so it acts as the default.

Why is IFS not available in my Excel?

IFS arrived in Excel 2019 and Microsoft 365. Older versions such as Excel 2016 show #NAME?, so use nested IFs there.

Practice IFS in these lessons

Guides that use IFS

Related functions

Updated 2026-10-31