Blanking Zero Values

J

J.E. McGimpsey

Look at Conditional Formatting in XL Help. Set the Font color to the
background color when the cell value is 0.
 
M

Mike A

You could also wrap your formula in an IF() function that returns null
if your formula result is zero:

=IF(yourformula=0."",yourformula)

Replace yourformula in the above function with the formula (without
the leading =) in the cells you want zeroes blanked in.

=A1+B1
becomes
=IF(A1+B1=0,"",A1+B1)
-Mike



Is there a way to blank zero values in only a section of a sheet?

TIA
Jerry
Click to expand...

Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
Top