Blanking Zero Values

[Jerry]

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

TIA
Jerry

 

[J.E. McGimpsey]

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

 

[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

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