To have the cell blank please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

It display's Sat 4
if cell blank color "red" 5
To leave a blank cell 6
Excel formula, sum the value cell and if empty cell left blank 0
To show blank please 2
Leave cell blank 7
If specific text result,... corresponing cell info in another colu 7
To Leave Cell blank Please 7

Back
Top