Need blank formula cells rather than 0's
 

I'm doing a simple spreadsheet with a few child sheets that point back to a
parent sheet with an overview of information. I've set of cells in the
parent sheet to simply look at another cell in the child sheet and copy it
across (eg =Sheet2!B3). The problem that I've got is that when cell B3 in
sheet 2 is blank it the cell in the parent sheets comes out with 0. Can
anyone tell my how to change the cell format so that it's just blank like the
child sheet.

Thanks

Need blank formula cells rather than 0's
 

You can do this two ways. Either modify your formulas as follows:

=if(Sheet2!B3="","",Sheet2!B3)

or you can just set your workbook not to show zero values.
Tools-Options-View tab. Uncheck 'Zero values"

Regards,
Paul

"carl" wrote in message
...
I'm doing a simple spreadsheet with a few child sheets that point back to
a
parent sheet with an overview of information. I've set of cells in the
parent sheet to simply look at another cell in the child sheet and copy it
across (eg =Sheet2!B3). The problem that I've got is that when cell B3 in
sheet 2 is blank it the cell in the parent sheets comes out with 0. Can
anyone tell my how to change the cell format so that it's just blank like
the
child sheet.

Thanks

Need blank formula cells rather than 0's
 

easiest would be tools/options/view and deselect "zero values".

"carl" wrote in message
...
I'm doing a simple spreadsheet with a few child sheets that point back to
a
parent sheet with an overview of information. I've set of cells in the
parent sheet to simply look at another cell in the child sheet and copy it
across (eg =Sheet2!B3). The problem that I've got is that when cell B3 in
sheet 2 is blank it the cell in the parent sheets comes out with 0. Can
anyone tell my how to change the cell format so that it's just blank like
the
child sheet.

Thanks

Need blank formula cells rather than 0's
 

=IF(ISBLANK(Sheet2!B3),"",Sheet2!B3)

OR

format your cells like this

#;-#;;@

this will make ALL zeros look like a blank cell, even if the original cell
contained a zero.

"carl" wrote:

I'm doing a simple spreadsheet with a few child sheets that point back to a
parent sheet with an overview of information. I've set of cells in the
parent sheet to simply look at another cell in the child sheet and copy it
across (eg =Sheet2!B3). The problem that I've got is that when cell B3 in
sheet 2 is blank it the cell in the parent sheets comes out with 0. Can
anyone tell my how to change the cell format so that it's just blank like the
child sheet.

Thanks