To have the cell blank please
 

Hello from Steved

Using the below what would I need to do to have the cell blank as at the
moment it is showing a 0 value

=SUM(B389:B413)

Thankyou.

Hi, Steve. :)

=if(sum(B389:B413)=0,"",sum(B389:B413))
*******************
~Anne Troy

www.OfficeArticles.com


"Steved" wrote in message
...
Hello from Steved

Using the below what would I need to do to have the cell blank as at the
moment it is showing a 0 value

=SUM(B389:B413)

Thankyou.

If what you're after is a neat, uncluttered look, think you could consider
switching off zero values display in the sheet via:
Tools Options Uncheck "Zero values" OK

This option averts the need to change existing formulas or to increase their
complexities to produce blanks: "" (null strings) via adding on error traps,
e.g.: =IF(SUM(B389:B413)=0,"",SUM(B389:B413)=0)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Steved" wrote in message
...
Hello from Steved

Using the below what would I need to do to have the cell blank as at the
moment it is showing a 0 value

=SUM(B389:B413)

Thankyou.

Typo:
e.g.: =IF(SUM(B389:B413)=0,"",SUM(B389:B413)=0)

should read:
e.g.: =IF(SUM(B389:B413)=0,"",SUM(B389:B413))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Another typo, sorry:
Tools Options Uncheck "Zero values" OK

should read as:
Tools Options View tab Uncheck "Zero values" OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Thankyou Anne

"Anne Troy" wrote:

Hi, Steve. :)

=if(sum(B389:B413)=0,"",sum(B389:B413))
*******************
~Anne Troy

www.OfficeArticles.com


"Steved" wrote in message
...
Hello from Steved

Using the below what would I need to do to have the cell blank as at the
moment it is showing a 0 value

=SUM(B389:B413)

Thankyou.