To have the cell blank please

[Steved]

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.

 

[Anne Troy]

Hi, Steve.

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

www.OfficeArticles.com

 

[Max]

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)

 

[Max]

Typo:

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

should read:

 

[Max]

Another typo, sorry:

Tools > Options > Uncheck "Zero values" > OK

should read as:

 

[Steved]

Thankyou Anne

Hi, Steve.

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

www.OfficeArticles.com