Linking sheets how do I display the zeros (0) as blank cells

[kat106]

I have a blank cell on the first worksheet that I am linking to a second
worksheet - when I link the two worksheets the blank cell now displays a zero
(0) on the linked sheet (second worksheet). I want this linked cell to be
displayed as blank with no zero (0) in the cell, how can I do this?

 

[T. Valko]

Try something like this:

=IF(Sheet2!A1="","",Sheet2!A1)