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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Turk" wrote:
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

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, ToolsOptionsView and uncheck Zero values

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Max" wrote in message
...
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Turk" wrote:
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

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.

"Turk" wrote:

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

Download ASAP utilities from the ASAP web site... It is a free addin
"Turk" wrote in message
...
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

I got it, thank you all~~

Turk


"MIchel Khennafi" ¼¶¼g©ó¶l¥ó·s»D
...
Download ASAP utilities from the ASAP web site... It is a free addin
"Turk" wrote in message
...
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