Excel IFS Function: What Happens If No Test Is TRUE?

Formulas & functions · Updated November 18, 2026

If every test in Excel’s IFS function is FALSE, the function returns #N/A; it does not have a separate built-in “value if false” argument. To provide a fallback, add TRUE as the last test and put your default result beside it. With a score in A2, for example, use =IFS(A2>=90,"A",A2>=80,"B",TRUE,"Below B"); if A2 is 72, the result is Below B.

Why IFS has no separate false value

IFS is designed to check a series of conditions and return the value associated with the first condition that evaluates to TRUE. Each condition is paired with its own result. If a condition is FALSE, Excel moves on to the next condition-result pair rather than returning a shared false result. That is why the function’s structure differs from IF, which has one condition and explicit true and false outcomes.

For example, in a grading formula, a score may meet the first threshold, a lower threshold, or none of them. If you include only the thresholds for A and B, a score below both thresholds has no matching result, so IFS returns #N/A. The error is a signal that the formula has exhausted its listed tests without finding a TRUE condition. It is not the same as Excel returning FALSE, zero, or an empty cell.

In everyday questions, “What is the IFS value if false?” usually means “What should I put in the formula for cases not covered by my conditions?” The usual answer is a final catch-all condition, or, in some situations, a different function such as IF.

How the IFS formula works

The syntax is IFS(logical_test1,value_if_true1,[logical_test2,value_if_true2],...). The square brackets in the syntax indicate optional repeated pairs; do not type the brackets into a formula. You need at least one logical test and its corresponding result. Excel accepts up to 127 condition-result pairs.

  • Logical test: An expression that Excel can evaluate as TRUE or FALSE, such as B2>=100 or A2="Complete".
  • Value if true: The result to return when that test is the first TRUE test, such as text in quotation marks, a number, a cell reference, or another calculation.
  • Next pair: Another test and result to consider if the preceding test is not TRUE.

Excel checks the conditions in the order they appear and returns the result corresponding to the first TRUE test. Later pairs do not provide a general false value for earlier tests; they describe other cases to check. For that reason, order matters when conditions overlap. A broad condition placed before a more specific one can match first and prevent the later result from being used.

Add a fallback with a final TRUE test

A final TRUE condition acts as the default because it is always TRUE. Excel reaches it only when none of the preceding tests matched. Put the fallback result immediately after it, just as you do for every other condition-result pair.

With a quantity in B2, use =IFS(B2>=100,"Large order",B2>=20,"Standard order",TRUE,"Small order"). A quantity of 12 returns Small order; a quantity of 35 returns Standard order; and a quantity of 120 returns Large order. The last pair covers all remaining values that reach it.

Use a fallback that describes the case accurately. “Other,” “Unclassified,” or “Check input” may be more useful than “No,” especially when the earlier tests classify categories rather than answer a yes-or-no question. If the input might be invalid, a message such as “Check input” makes that visible instead of silently treating unexpected data as a valid category.

Choose conditions and order them carefully

Before adding a catch-all, check whether your tests cover the values you intend. For numeric ranges, list boundaries in a clear order and avoid gaps or unintended overlaps. With a score in A2, this formula assigns scores of 90 and above to A, scores from 80 through 89 to B, and anything below 80 to Below B: =IFS(A2>=90,"A",A2>=80,"B",TRUE,"Below B"). Because the higher threshold is checked first, scores at or above 90 do not get labelled B.

If you instead put A2>=80 before A2>=90, a score of 95 would match the first test and return B. The more specific high-score condition would never get a chance to determine the result. For text labels, also consider capitalization, spelling, and extra spaces in the source data; a test for one exact text value will not classify a different spelling as that value.

For a mutually exclusive set of labels, put each intended category in a test and reserve the final TRUE pair for anything outside those categories. If there should be no fallback category, leaving out that pair is valid—but you must be prepared for #N/A when no test matches.

Handle blanks and unexpected input

A blank cell may fall through your ordinary tests and produce #N/A. If a blank input should produce a blank-looking result, test for it first. With a status in A2, use =IFS(A2="","",A2="Open","In progress",A2="Closed","Finished",TRUE,"Check status"). An empty text result displays as blank, although the cell still contains a formula. The first test prevents a blank A2 from reaching the fallback.

Think about whether a fallback should hide or expose bad data. In the example, any nonblank value other than Open or Closed displays Check status. That can help identify misspellings such as “Close” or unexpected imported values. Replacing the fallback with an empty string would make the worksheet look tidier but could conceal the fact that an input was not recognized.

Also distinguish an empty cell from a cell containing a space or a formula that returns an empty string. Those can behave differently in comparisons. If data comes from a form, export, or copy-and-paste operation, inspect representative inputs and decide which kinds of blank or malformed values the formula should handle.

Common errors and troubleshooting

  • #N/A: No condition evaluated as TRUE. Add a final fallback pair if that is an expected case, or correct the tests if a case was supposed to match.
  • Wrong category: Check the order for overlapping conditions. Put the narrow or higher-priority condition first.
  • Formula syntax error: Check that every test has a matching result, quotation marks are straight, and parentheses are balanced. A text result must be enclosed in quotation marks.
  • Unexpected classification: Check the underlying cell for spaces, text stored where a number was expected, or values outside the assumed range.

Excel’s regional settings can affect the argument separator shown in formulas. The examples here use commas, as requested for standard English-language Excel syntax; some installations require semicolons between arguments. If Excel rejects a correctly structured formula, check the list separator used by your installation rather than changing the logic.

Be cautious about wrapping the entire expression in IFERROR just to remove #N/A. For example, with a score in A2, =IFERROR(IFS(A2>=90,"A",A2>=80,"B"),"Below B") returns Below B when no threshold matches. But it can also replace other errors arising inside the expression with the same text, making a different problem harder to spot. A final TRUE pair is generally clearer when the intended case is simply “none of these tests matched.”

IFS compared with IF and IFERROR

Use IFS when you have several conditions that each need a distinct result and want to avoid stacking many IF functions inside one another. Use IF when there is one decision with a clear true result and a clear false result. With a score in A2, =IF(A2>=80,"Pass","Fail") returns Pass for 80 or higher and Fail otherwise. In this case the false result is explicit because IF has a third argument for it.

Use IFERROR when you deliberately want to replace an error result, not simply because a condition is false. An unmatched IFS produces #N/A, but a test can also encounter another problem—for example, a referenced formula may itself return an error. A broad IFERROR can hide both situations. If the goal is to classify ordinary unmatched values, an explicit final TRUE test says exactly what the formula should do.

For a long list of mappings maintained by other people, a lookup table may be easier to update than a lengthy formula. For a small number of ranges or categories, IFS can be straightforward to read. The best choice depends on how many cases there are, whether they change often, and whether unmatched inputs should display a default, an error, or a visible warning.

Availability and entering the formula

IFS is available in Excel for Microsoft 365 and in Excel 2019 and later perpetual versions, including Excel 2021 and Excel 2024. It is not available in Excel 2016 and earlier; opening a workbook containing the function in an older version can result in an unsupported-function display. In that case, nested IF functions are a common compatible alternative.

In Microsoft 365 for Windows, select the result cell, type the formula beginning with =IFS(, and press Enter. Excel for Mac and Excel for the web use the same function and formula logic; the interface and keyboard shortcuts can differ, but no special Mac or web version of the IFS syntax is needed. If the worksheet contains many rows, enter the formula in the first result row and use the fill handle or copy and paste to extend it, then check that the cell references adjust as intended.

Frequently Asked Questions

What does IFS return if all conditions are false?
If no test is TRUE and there is no final catch-all test, IFS returns #N/A. Add a final TRUE condition and the result you want for all remaining cases.

Can I put a value_if_false argument in IFS?
No. IFS uses condition-result pairs, not a separate false argument. Each failed test leads Excel to the next pair. A final TRUE pair provides the usual default behavior.

Does IFS have to end with TRUE?
No. Use a final TRUE pair when you want a catch-all result. Without one, unmatched cases return #N/A, which may be useful if you want missing classifications to stand out.

Can the default result be blank?
Yes. Put an empty text string, written as two quotation marks with nothing between them, after the final TRUE test. The formula returns a blank-looking cell, but the cell still contains the formula.

Should I use IFS or nested IF functions?
Use IFS for a readable series of condition-result pairs. Use IF for a simple two-outcome decision, or nested IF functions when you need compatibility with older Excel versions that do not support IFS.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.