Formula Errors

Return a Blank When an Excel Formula Produces an Error

Phi Hung VoPhi Hung Vo Nov 18, 2026 869 views

Question details

Return a blank when a conditional subtraction formula produces an error, and prevent errors from appearing on linked worksheets.

Return a Blank When an Excel Formula Produces an Error
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.
Before you start

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.

Solution 1Recommended

Wrap the conditional subtraction in IFERROR

Use this formula to display a blank when the condition is false or the calculation returns an error.

1
Select the formula cell

In Excel, select the cell where you want the conditional subtraction result to appear.

2
Enter the formula

In the formula bar, enter =IFERROR(IF(A12=6,E11-B12,""),"") and press Enter. Replace the cell references if your worksheet uses different cells.

3
Handle linked formulas

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,"").

4
Check the results

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.

Wrap the conditional subtraction in IFERROR
A displayed blank is not an empty cell: The formula returns an empty string, not a truly empty cell. IFERROR also hides errors other than #VALUE!, so check the source values if an unexpected blank appears.
Work with formulas in WPS Spreadsheets

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. 1. Open the workbook: Launch WPS Spreadsheets and use Open to select your Excel workbook.
  2. 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. 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. 4. Test and save: Test the formula with numeric and text values, then use File > Save to save the workbook.
Use IFERROR to display a blank instead of a formula errorOpen and edit Microsoft Excel XLSX and XLS filesWork with familiar spreadsheet formulas and a familiar interface
microsoft office alternative - wps office

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.