ExcelBanter - Linked Cell Range

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Linked Cell Range (https://www.excelbanter.com/excel-discussion-misc-queries/70848-linked-cell-range.html)

Linked Cell Range

How do I not display a "0" when a series of linked cells initially have no
information?

Dave Peterson

Linked Cell Range

=if(sheet1!a1="","",sheet1!a1)

JK wrote:

How do I not display a "0" when a series of linked cells initially have no
information?

--

Dave Peterson

All times are GMT +1. The time now is 03:29 AM.