ExcelBanter - 0 in linked cells when watched

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - 0 in linked cells when watched (https://www.excelbanter.com/excel-worksheet-functions/56792-0-linked-cells-when-watched.html)

steve

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.??

Roger Govier

0 in linked cells when watched

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.??

All times are GMT +1. The time now is 11:19 PM.