Some results that I do not want to Print

M

Melody

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
 
G

Gord Dibben

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

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


Gord Dibben MS Excel MVP
 
B

Bernard Liengme

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
 

Ask a Question

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.

Ask a Question

Similar Threads

Adding numbers and text 4
Array formula - help with #NUM! errors 0
Standard Deviation and Averages based on criteria 2
... I want to print $0.00 if ... 2
Formula help 1
How do I reference one OR another worksheet? 2
What is wrong with this Formula??? 4
When dividing by 0 can i show a result of 0 instead of #DIV/0 7

Top