How to return a blank cell if sum = 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

waybomb - 19 Jul 2007 15:02 GMT

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?

Reply to this Message

Billy Liddel - 19 Jul 2007 15:42 GMT

=If(myformula=0,"",myformula), say, +if(sum(A3:g3)=0,"",Sum(a3:g3))

Peter

> 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?

Reply to this Message

Rick Rothstein (MVP - VB) - 19 Jul 2007 16:24 GMT

> 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?

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

Reply to this Message

Peo Sjoblom - 19 Jul 2007 16:29 GMT

Custom format General;-General;

will not display a zero

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

Signature

Regards,

Peo Sjoblom

> 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?

Reply to this Message

Rate this thread: