Help Again! :)

[pmidwest]

I gotta thank you guys again for the help on the formula earlyer... but now when I print, on the second sheet any cell that I didnt enter info in on the first sheet prints out a "0" on the second sheet... is there anyway to hide these 0's?

 

[Knoxville]

Try putting something like:

=If(Sheet!Range="","",Sheet!Range)

e.g.

=If(Input!B10="","",Input!B10)

Hopefully this should look at the input cell, if it's null then it will put a null value in your output cell, if it's not null then it should put the input value in the output cell.

Give it a try, let me know.

Cheers

Knoxville

 

[chifu]

I did not see your earlier posts so do not know what your formulars where, but how about putting in an IF statement which says something like this;

IF (datacell) = "" then "", exsiting formular.

 

[pmidwest]

Very Cool! Thanks alot guys

 

[HoosierDaddy]

If you want to hide them in an entire sheet, you can also turn it off in Tools > Options | View tab. To hide them, clear the Zero Values check box.

If you want specific cells, you can also:
1. Highlight the cells (non-contiguous cells by holding CTRL and clicking)
2. Click Format > Cells
3. On the Number tab, choose Custom format
4. In the Type window, enter 0;-0;;@
5. Click OK.

This will hide the zero values in the cell and prevent them from printing, but you will be able to see them in the Formula Bar.

Sorry if I've restated what others may have entered. Feeling less-than-inept today and thought I'd share.