Microsoft Excel help needed?

Question

I have a workbook with 9 pages. Each of the pages get information from the previous page except the last two which pull information from all the page. Basically it's a daily sales report which automatically generates a weekly report.

On the weekly report I want the cells that pull information from the daily report to remain blank if the daily number is 0. How would I write the custom format for that? If possible, I don't even want the symbol to show up when the cell value is 0.

Serena: your solution work perfectly except for one thing. When the cell is used to calculate another cell, the calculated value will read #Value! when the value is 0.

For example if c1 has the formula "if(Fri!c1=0,"",Fri!c1)" and the value is 0.

The cell with the formula c1+c5 will read #Value!. But it works fine when c1 has a value other than 0.

Answer 1

You should be able to do an "if...then" statement. Like "if (A1=0,"",) then
after the "", put in the value you want to appear in the celll
For example, if the value you want coordinates to A1 on the other sheet, you'd say:

if(A1=0, "", A1)

Try using this in the cell that you don't want zero to appear in. Should work.

if(A1=0, the mark here is two quote marks, A1)

Answer 2

Use the 'IF' statement. =If(C3=0, "", C3). That should work but I do not know all the details.