Display a blank cell when sum is zero

  • Thread starter Thread starter charlymon
  • Start date Start date
C

charlymon

How do I make a cell display a blank instead of a "0" or a "-" when
the sum of a formula is zero?
 
Hi,

Try going to [Tools] --> Options

Under the tab "View"

Look at the Window option and uncheck Zero Values

Rockee Freema
 
Hi Charlymon!

Example:

=IF(SUM(A1:Z1)=0,"",SUM(A1:Z1))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi

=IF(MyFormula="","",MyFormula)
(Put your sum formula instead MyFormula into it)
 

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

Excel formula, sum the value cell and if empty cell left blank 0
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
keeping a cell blank 4
Blank cells in a formula 2
Zero and Null Sum Function 2
Formatting Cell that displays sum from other worksheets 3
Adding only NONBLANK cells 2
VLOOKUP returns 0 (zero) when lookup cell is blank 5

Back
Top