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
 
Back
Top