Need blank formula cells rather than 0's

C

carl

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
 
P

PCLIVE

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
 
S

Sloth

=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.
 
Top