Displaying linked data as zero

[Mark]

In a "daughter" spreadsheet with links to a "parent"
spreadsheet, the daughter cells display the number "zero"
when the parent cells are empty. I would like these
daughter cells to be blank rather than display a zero.
Anyone know how to accomplish that?

THANK YOU, in advance ...

Mark

 

[Frank Kabel]

Hi Mark
try something like
=IF('sheet1'!A1="","",'sheet1'!A1)