How to hide "0" in a cell?

  • Thread starter Thread starter Turk
  • Start date Start date
T

Turk

Dear all,

I have a formula "=sum(a1:a4)" at cell a5, normally it will display a "0"
when cells a1 to a4 are all blank. How can I hide this "0"?

Thanks


Turk
 
Trap it with and IF, eg use instead in A5:
=IF(SUM(A1:A4)=0,"",SUM(A1:A4))

Alternatively, perhaps better,
we can easily suppress the display of zeros in the sheet via clicking:
Tools > Options > View tab > Uncheck "Zero values" > OK
 
Trap it with and IF, eg use instead in A5:
=IF(SUM(A1:A4)=0,"",SUM(A1:A4))

Alternatively, perhaps better,
we can easily suppress the display of zeros in the sheet via clicking:
Tools > Options > View tab > Uncheck "Zero values" > OK
 
You could format it

0;-0;;

You could use Conditional Formatting to set the font to white for a zero
value

or you could suppress zeros, Tools>Options>View and uncheck Zero values

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You could format it

0;-0;;

You could use Conditional Formatting to set the font to white for a zero
value

or you could suppress zeros, Tools>Options>View and uncheck Zero values

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Try something like
=if(countblank(A1:A4)=4,"",sum(A1:A4))
this will let you have a sum of zero if a zero is actually in one of the
cells.
 
Try something like
=if(countblank(A1:A4)=4,"",sum(A1:A4))
this will let you have a sum of zero if a zero is actually in one of the
cells.
 
Back
Top