Prevent #N/A in an Excel IFS Formula
Question details
Return a blank-looking result from an IFS formula when none of its conditions is true.

- 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.
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.
Add a Default Result to the IFS Formula
Use a final TRUE condition to return an empty string when no earlier condition matches.
Click the cell containing the IFS formula, then click the formula bar.
Add TRUE and an empty string as the final condition-and-result pair, for example: =IFS(condition1,result1,condition2,result2,TRUE,"").
Press Enter, then test values that make every earlier condition false. The cell should display no text instead of #N/A.

Wrap the IFS Formula in IFERROR
Use IFERROR when you want a blank-looking result for any error returned by the complete formula.
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. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Select the formula: Click the cell containing the IFS formula, then click the formula bar.
- 3. Add the fallback: Add TRUE,"" as the final condition-and-result pair, such as =IFS(condition1,result1,TRUE,""). Press Enter.
- 4. Check and save: Test a value that does not match an earlier condition, then use File > Save to save the workbook.

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.




