excel 2003 problem w/zero and blank cells

[Meenie]

I'm copying information from one spreadsheet to another. The problem I'm encountering is when a cell is blank, it copies over as zero. but I want it to copy over as blank if it's blank, not as a zero as the new spreadsheet row will be averaged and the zero will mess up the average.
The formula I have in each cell is simply "=worksheet1!E19"
What do I need to add to the formula to make it keep the cell blank if it's blank on the original worksheet?
Thanks

 

[T. Valko]

I'm copying information from one spreadsheet to another. The problem I'm encountering is when a cell is blank, it copies over as zero. but I want it to copy over as blank if it's blank, not as a zero as the new spreadsheet row will be averaged and the zero will mess up the average.
The formula I have in each cell is simply "=worksheet1!E19"
What do I need to add to the formula to make it keep the cell blank if it's blank on the original worksheet?
Thanks

Like this...

=IF(worksheet1!E19="","",worksheet1!E19)

 

[Meenie]

this makes the cell in the new spreadsheet say "false" instead of being blank.

 

[Meenie]

Ok, I figured it out "=If(range=0,"",range) works