printing without zeros showing in a cell with formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a workbook that totals 5 worksheets (for Monday thru Friday) on
a 6th worksheet that is printed and posted weekly. However, because there is
a formula in each cell on the weekly sheet, a zero appears in all of the
cells which makes the sheet being posted look too too busy... Is there a way
to have the weekly worksheet leave all cells blank unless there is actual
data pulled?
 
Trap for no data or zero in source cell(s).

=IF(Sheet1!A1=0,"",Sheet1!A1)

=IF(Sheet1!A1="","",Sheet1!A1)

=IF(SUM(Sheet1:Sheet5!A1:A10)=0,"",SUM(Sheet1:Sheet5!A1:A10))


Gord Dibben MS Excel MVP
 
Another way is to apply conditional formatting to the cells in the
summary sheet, such that if the cell content is zero, change the
foreground colour to the background colour (usually white).

Hope this helps.

Pete
 

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

formula result is zero but zero is not populating in cell 3
Linking sheets how do I display the zeros (0) as blank cells 1
Printing Dates on One Sheet 5
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
How do I copy a date in a worksheet cell to another worksheet? 3
Conditional Formatting on cell with a formula 5
Why won't target cell data changes trigger formula evaluation? 3
Hide columns based on row values 2

Back
Top