Some results that I do not want to Print
 

In certain cells that contain formulas, the results gives me a Zero or where
the results gives me an error message....I want to see this on the screen,
however, I do not want these results to print. Here are my examples:
C40 =SUM(C8:C38) ....nothing has been entered into C8:C38, so the result
is 0.
or
C41 =Average(C8:C38) ....no entries in C8:C38, resulting in error: #DIV/0!

These results are great on the screen, but I do not want them to print out.
-- Melody

Some results that I do not want to Print
 

=IF(SUM(C8:C38=0,"",SUM(C8:C38))

=IF(ISERROR(AVERAGE(C8:C38)),"",AVERAGE(C8:C38))


Gord Dibben MS Excel MVP

On Thu, 21 Feb 2008 11:33:00 -0800, Melody
wrote:

In certain cells that contain formulas, the results gives me a Zero or where
the results gives me an error message....I want to see this on the screen,
however, I do not want these results to print. Here are my examples:
C40 =SUM(C8:C38) ....nothing has been entered into C8:C38, so the result
is 0.
or
C41 ....no entries in C8:C38, resulting in error: #DIV/0!

These results are great on the screen, but I do not want them to print out.
-- Melody

Some results that I do not want to Print
 

If the number of cells is small, use conditional formatting to have the font
the same colour as the background if certain conditions apply (ie =C40=0 or
=ISERROR(C41)). On the screen you can se the value in the cell when it is
selected.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Melody" wrote in message
...
In certain cells that contain formulas, the results gives me a Zero or
where
the results gives me an error message....I want to see this on the screen,
however, I do not want these results to print. Here are my examples:
C40 =SUM(C8:C38) ....nothing has been entered into C8:C38, so the result
is 0.
or
C41 =Average(C8:C38) ....no entries in C8:C38, resulting in error:
#DIV/0!

These results are great on the screen, but I do not want them to print
out.
-- Melody