Why Excel MIN Returns a Blank Result from Formula Cells
Question details
Determine why a MIN formula appears blank when it references cells containing formulas.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user calculates the minimum of cells P59:P82 on the FDS RECTO sheet, where each cell contains a MIN formula referring to another range.
- Observed behavior
- The MIN result appears blank, although some referenced formulas may return zero because their source cells are empty.
Select a few cells in 'FDS RECTO'!P59:P82 and check their formulas and source ranges. Confirm whether empty source rows should be excluded and whether genuine zero values should remain in the calculation.
Exclude empty source rows from the Excel MIN calculation
Use this approach when empty source rows should not affect the minimum but genuine numeric zeros should count.
MIN returns zero when its referenced range contains no numbers. A COUNT check can make an empty source row return an empty string instead, which MIN ignores in a referenced range.
On the FDS RECTO sheet, select P59 and enter =IF(COUNT(Q59:S59)=0,"",MIN(Q59:S59)).
Drag the fill handle from P59 down through P82 so each row checks its own Q:S range.
In the result cell, enter =IF(COUNT('FDS RECTO'!P59:P82)=0,"",MIN('FDS RECTO'!P59:P82)). This leaves the result blank only when the range has no numeric results.

Show zero values in Excel
Use this option when the result is zero and you want Excel to display it rather than hide it.
Handle empty rows in a MIN formula with WPS Spreadsheets
Open the workbook in WPS Spreadsheets and use COUNT with MIN to exclude empty source rows while retaining genuine zeros.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Edit the source formula: On the FDS RECTO sheet, select P59 and enter =IF(COUNT(Q59:S59)=0,"",MIN(Q59:S59)).
- 3. Fill down: Drag the fill handle from P59 through P82 to apply the formula to the remaining rows.
- 4. Calculate the overall minimum: In the result cell, enter =IF(COUNT('FDS RECTO'!P59:P82)=0,"",MIN('FDS RECTO'!P59:P82)), then save the workbook.

Frequently Asked Questions
Why does MIN return zero when the source cells are empty?
MIN returns 0 when its referenced range contains no numbers. A formula such as =MIN(Q59:S59) can therefore produce zero for an empty source row.
How do I show a hidden zero in Excel?
Go to File > Options > Advanced. Under Display options for this worksheet, select the worksheet and enable Show a zero in cells that have zero value.
Will MIN ignore formulas that return an empty string?
Yes. When MIN references a range, it ignores empty strings returned by formulas in that range. If the range contains no numbers, MIN itself returns 0.
How can I keep the overall result blank when every source row is empty?
First make empty source rows return an empty string, then use =IF(COUNT('FDS RECTO'!P59:P82)=0,"",MIN('FDS RECTO'!P59:P82)) in the result cell.
Will the COUNT approach exclude real zero values?
No. COUNT includes numeric zeros, so a genuine zero remains part of the MIN calculation. Use a zero-checking IF formula only if all zero results should be treated as blank.




