Tools-->Options-->View check off Zero Values. You could also
incorporate an If statement into a formula, if you are only trying to
hide the 0s for formulated cells.
=IF(M5-M4=0,"",M5-M4)
You can't "hide" a cell the way you can hide a row or column, but you can
make it appear blank.
Option 1: Wrap your formula in an if statement like this...
=IF(SUM(data)=0,"",SUM(data))
Option 2: Make a custom number format that outputs nothing for zero values.
highlight the cells in question
select format->cells->number tab
under "category" click on "custom"
enter the following under "type"
General;-General;;@
The solution you choose will depend on how you want the zeroes to
affect other functions.
Option 1 is suitable if you want average function to ignore zero sum.
Option 2 is what you need to include the zeroes in AVERAGE(). Also,
COUNT() will omit blanks but include zeroes.
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.
