Return a Blank When an Excel Formula Produces an Error
Question details
Return a blank when a conditional subtraction formula produces an error, and prevent errors from appearing on linked worksheets.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet subtracts cells that may contain text, and other worksheets use related formulas or references.
- Observed behavior
- The subtraction can produce a #VALUE! error, which may also appear in formulas on linked worksheets.
Identify the cell containing the subtraction formula and check which worksheets reference its result. Confirm that A12 is the condition cell and that E11 and B12 are the cells to subtract, or adjust the references to match your workbook.
Wrap the conditional subtraction in IFERROR
Use this formula to display a blank when the condition is false or the calculation returns an error.
In Excel, select the cell where you want the conditional subtraction result to appear.
In the formula bar, enter =IFERROR(IF(A12=6,E11-B12,""),"") and press Enter. Replace the cell references if your worksheet uses different cells.
On each linked worksheet, select any formula cell that can still return an error and wrap its existing formula in IFERROR. For example, change =Sheet1!C1/Sheet1!D1 to =IFERROR(Sheet1!C1/Sheet1!D1,"").
Test the formula with numeric values and with text in a subtraction cell. When A12 equals 6 and the subtraction works, the cell should show the result; otherwise, it should display a blank.

Return a Blank on Formula Errors in WPS Spreadsheets
Open your workbook in WPS Spreadsheets and use IFERROR with IF to hide errors from conditional subtraction. You can apply the same approach to formulas on linked worksheets.
- 1. Open the workbook: Launch WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Enter the formula: Select the result cell and enter =IFERROR(IF(A12=6,E11-B12,""),"") in the formula bar. Adjust the references as needed, then press Enter.
- 3. Check linked worksheets: Open each linked worksheet tab and wrap formulas that may return errors in IFERROR, using an empty string as the fallback.
- 4. Test and save: Test the formula with numeric and text values, then use File > Save to save the workbook.

Frequently Asked Questions
Why does subtracting cells in Excel return #VALUE!?
A subtraction formula such as =E11-B12 can return #VALUE! if a referenced cell contains text that Excel cannot use as a number. Check E11 and B12, or wrap the calculation in IFERROR to display a different result.
How do I show a blank when A12 is not 6?
Use =IF(A12=6,E11-B12,"") in the result cell. To also hide errors from the calculation, use =IFERROR(IF(A12=6,E11-B12,""),"").
Will IFERROR make the cell truly empty?
No. IFERROR with "" returns an empty string, so the cell looks blank but still contains a formula. This distinction can affect formulas that test whether a cell is empty.
How can I hide errors on a linked worksheet?
Select the formula cell on the linked worksheet and wrap its existing formula in IFERROR. For example, use =IFERROR(Sheet1!C1/Sheet1!D1,"") to display a blank if that calculation returns an error.




