Quick Answer

IFS Function

A simpler way to write multiple IF statements without nesting.

Syntax

IFS

(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)

Parameters

Parameter	Description	Required
logical_test1	The first condition to evaluate.	Required
value_if_true1	The value to return if logical_test1 is true.	Required
logical_test2, value_if_true2	Additional test/value pairs (optional).	Optional

Basic Example

Assign a grade based on a score

=IFS(A2>=90, "A", A2>=80, "B", A2>=70, "C", A2<70, "D")

ResultLetter grade

Returns the first grade where the condition is true. If A2 is 85, returns "B".

Advanced Examples

Example 1: Nested conditions with default

Commission rates

Return a commission rate with a fallback

=IFS(A2>=10000, 0.1, A2>=5000, 0.07, A2>0, 0.05, TRUE, 0)

Result: Commission rate

The TRUE condition at the end catches any remaining cases, acting as a default.

How IFS Works

IFS evaluates each logical test from left to right. As soon as a test is true, it returns the corresponding value. If no test is true and no default TRUE condition is provided, it returns #N/A.

1

Write first condition

Enter the first logical test and its return value.

2

Add more pairs

Continue adding condition/value pairs.

3

Add default if needed

Use TRUE as the last condition to return a default value.

Important Notes & Limitations

Requires Excel 2019 or Excel 365; not available in older versions.
No explicit value_if_false argument; use a default TRUE condition.
Stops at the first true condition.

Common Errors & Fixes

#N/A errorNo condition is true and no default condition is provided.

Fix: Add TRUE, "default value" as the last pair.

#VALUE! errorA logical test does not evaluate to TRUE/FALSE.

Fix: Ensure tests return boolean values.

Download Practice File

Practice IFS with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the IFS function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Functions

AND

AND checks if ALL conditions are TRUE.

FALSE

Returns the logical value FALSE.

IF

IF checks a condition and returns different values based on whether it is true or false.

IFERROR

IFERROR catches errors and returns a custom value instead.

IFNA

Replaces #N/A errors with a fallback value.

NOT

NOT flips TRUE to FALSE and FALSE to TRUE.

Frequently Asked Questions

What is the difference between IF and IFS?

IF handles one condition. IFS handles multiple conditions in a flat list without nesting.

Can I use IFS in Excel 2016?

No, IFS requires Excel 2019 or Excel 365 or later.

How do I add a default value in IFS?

Use TRUE as the final condition: IFS(..., TRUE, "default").