0 in linked cells when watched

i have linked some cells in excell to another work sheet but if sheet 1 has
no data in the cell then sheet 2 shows a 0 how do i keep the linked / watched
cell but not return the zero on the second sheet.??

Hi Steve

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

Regards

Roger Govier


steve wrote:
> i have linked some cells in excell to another work sheet but if sheet 1 has
> no data in the cell then sheet 2 shows a 0 how do i keep the linked / watched
> cell but not return the zero on the second sheet.??