How to return a blank cell if sum = 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I show a blank cell, instead of the number 0 in the cell, if the
formula in that cell results in an answer of 0?
 
How would I show a blank cell, instead of the number 0 in the cell,
if the formula in that cell results in an answer of 0?
Click to expand...

Another option... if you want zero values to not show **anywhere** on your
worksheet, you can turn them off globally for the worksheet in question. If
you have more than one worksheet, make sure the one you want to turn zeroes
off in is active. Click Tools/Options on Excel's menu bar, select the View
tab from the dialog box and uncheck the Zero Values option in the Window
Options section.

Rick
 
Custom format General;-General;

will not display a zero

apply the same method if you have currency, number formats etc
 
Back
Top