Hide zero results so reports show empty cells instead.
Copy this formula
=IF(A2=0, "", A2)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.
=IF(SUM(B2:B5)=0, "", SUM(B2:B5))→(blank)Empty cell when the total is zero.
=IF(B2-C2=0, "", B2-C2)→(blank)Leaves the cell empty when the two values are equal.
=IF(VLOOKUP(E2, A:B, 2, FALSE)=0, "", VLOOKUP(E2, A:B, 2, FALSE))→(blank)Stops a lookup from showing 0 when the matched cell is empty.
Hide zeros sheet-wide
—Or turn off File ▸ Options ▸ Show a zero in cells.
Visually yes, but ISBLANK sees it as non-empty. Use COUNTBLANK, which does count "".
Apply the custom number format 0;-0;;@ to the cells. Zeros are hidden, but the cells still contain 0 for calculations.
Excel returns 0 when a formula points at an empty cell. Wrap the lookup in IF as shown above to return a blank instead.
It can. "" is text, so adding it with + returns #VALUE!, while SUM simply ignores it. Use SUM, or keep the 0 and hide it with a number format.
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.