Keep Excel Formula Cells Blank When Referenced Cells Are Empty
Question details
Keep formula results blank until the relevant source cell contains a value.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet uses WORKDAY to calculate a date and a comparison formula to return Yes or No.
- Observed behavior
- When a referenced cell is empty, WORKDAY can display a date based on Excel's zero date, and a comparison can return No.
Identify the source cells used by each formula and the cells where you want the results to appear. Check whether the comparison should use less than (<) or less than or equal to (<=).
Wrap the WORKDAY and comparison formulas in IF
Use an IF check to display an empty result until the relevant source cell has a value.
Select the WORKDAY result cell and enter =IF(C4="","",WORKDAY(C4,10)). It stays blank when C4 is empty and otherwise calculates a date 10 workdays after C4.
Select the Yes/No result cell and enter =IF(E4="","",IF(F4<E4,"Yes","No")). It stays blank when E4 is empty and otherwise compares F4 with E4.
Use the fill handle to copy each formula to other rows, then enter and remove source values to check the results. Adjust the cell references for your worksheet as needed.

Keep Formula Results Blank in WPS Spreadsheets
Use the same IF checks in WPS Spreadsheets to hide WORKDAY and comparison results until the source cells contain values.
- 1. Open your workbook: Open WPS Spreadsheets and select your Excel workbook.
- 2. Enter the date formula: Select the date result cell and enter =IF(C4="","",WORKDAY(C4,10)), replacing C4 with your source cell if needed.
- 3. Enter the comparison formula: Select the comparison result cell and enter =IF(E4="","",IF(F4<E4,"Yes","No")), adjusting the references for your sheet.
- 4. Fill and save: Drag the fill handle to apply the formulas to other rows, then use File > Save to save the workbook.

Frequently Asked Questions
Why does WORKDAY show a date when its source cell is empty?
Excel can treat an empty date reference as zero in a calculation. Use =IF(C4="","",WORKDAY(C4,10)) to avoid calculating until C4 has a value.
How do I keep a Yes/No result blank until both cells are filled?
Use =IF(OR(E4="",F4=""),"",IF(F4<E4,"Yes","No")). This checks both E4 and F4 before comparing them.
How can the comparison return Yes when the values are equal?
Replace < with <= in the comparison, for example: =IF(E4="","",IF(F4<=E4,"Yes","No")).
Is a cell with a formula returning an empty string truly empty?
No. The cell still contains a formula, even though the formula displays an empty string. An IF check such as C4="" also treats a formula result of "" as blank.




