Conditional Logic

Excel formula for Show a blank instead of zero

Hide zero results so reports show empty cells instead.

Copy this formula

=IF(A2=0, "", A2)

How the formula works

IF tests for zero and returns an empty string when true, otherwise the value. It keeps totals and charts clean. For formula outputs that may error, combine with IFERROR.

Examples

=IF(SUM(B2:B5)=0, "", SUM(B2:B5))→(blank)

Empty cell when the total is zero.

Other ways to do this

Hide zeros sheet-wide

—

Or turn off File ▸ Options ▸ Show a zero in cells.

FAQ

Does an "" result count as blank?

Visually yes, but ISBLANK sees it as non-empty. Use COUNTBLANK, which does count "".

Related formulas

Flag or handle blank cells Hide errors with IFERROR

Functions used

IF IFERROR

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free