Thread: [Solved] Zero (0) in cell
View Single Post
 
Old 01-18-2011, 07:26 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by ConneXionLost View Post
You can use a custom format like this:

Code:
#,##0_);(#,##0);""
but, be warned, it will hide ALL zeros.
No, it'll only hide 0s in the cells to which the custom format is applied.

An alternative is to modify the formula. For example:
=IF(A1+B1=0,"",A1+B1)
or:
IF(OR(A1=0,B1=0),"",A1+B1)
The first hides the result only if it evaluates to 0, whereas the second hides the result if either of the inputs is 0.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote