Formula Errors

Prevent #N/A in an Excel IFS Formula

John WilsonJohn Wilson Nov 18, 2026 869 views

Question details

Return a blank-looking result from an IFS formula when none of its conditions is true.

Prevent #N/A in an Excel IFS Formula
Product
Microsoft Excel
Device & OS
not provided
Scenario
An IFS formula supplies a result to another formula, but it needs a fallback when no condition matches.
Observed behavior
The IFS formula returns #N/A when all its conditions are false.
Before you start

Select the cell containing the IFS formula and review its condition-and-result pairs in the formula bar. Check which result should appear when no condition matches.

Solution 1Recommended

Add a Default Result to the IFS Formula

Use a final TRUE condition to return an empty string when no earlier condition matches.

1
Select the formula cell

Click the cell containing the IFS formula, then click the formula bar.

2
Add the fallback pair

Add TRUE and an empty string as the final condition-and-result pair, for example: =IFS(condition1,result1,condition2,result2,TRUE,"").

3
Test the result

Press Enter, then test values that make every earlier condition false. The cell should display no text instead of #N/A.

Add a Default Result to the IFS Formula
An empty string is not an empty cell: The formula returns "", so the cell only looks blank. A dependent formula can test for this result with a comparison such as =A1=""; ISBLANK(A1) returns FALSE because the cell contains a formula.
Work with formulas in WPS Office

Add an IFS Fallback in WPS Spreadsheet

In a WPS Spreadsheet version that supports IFS, add a final TRUE condition to return an empty string when no earlier condition matches.

  1. 1. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Select the formula: Click the cell containing the IFS formula, then click the formula bar.
  3. 3. Add the fallback: Add TRUE,"" as the final condition-and-result pair, such as =IFS(condition1,result1,TRUE,""). Press Enter.
  4. 4. Check and save: Test a value that does not match an earlier condition, then use File > Save to save the workbook.
Add a default result to an IFS formula to avoid an unmatched-condition #N/A.Open and save Microsoft Excel XLSX files.Edit formulas in a familiar spreadsheet interface.Use WPS Office for free.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my IFS formula return #N/A?

IFS returns #N/A when none of its conditions is true and no default condition is provided. Add TRUE,"" as the final condition-and-result pair to display a blank-looking result.

Can I hide only #N/A errors instead of every error?

Yes. Wrap the formula in IFNA, for example =IFNA(IFS(condition1,result1),""). This catches #N/A errors from the formula but leaves other error types visible.

Is a formula that returns an empty string truly blank?

No. The cell contains a formula even though it displays no text. A dependent formula can compare the cell to "", but ISBLANK returns FALSE.

Why does Excel reject the formula when I use commas?

Some regional settings use semicolons as formula argument separators. If Excel expects semicolons, replace the commas between arguments with semicolons.