ExcelBanter - Linking two spreadsheets

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

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

- - Linking two spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/65391-linking-two-spreadsheets.html)

Dave

Linking two spreadsheets

Empty cells in original file link as a "0" in a destination, how can I
prevent displaying of "0's" in a destination, but keep the link as a working
link?

Dave Peterson

Linking two spreadsheets

=if(yourlinkformula="","",yourlinkformula)

Dave wrote:

Empty cells in original file link as a "0" in a destination, how can I
prevent displaying of "0's" in a destination, but keep the link as a working
link?

--

Dave Peterson

All times are GMT +1. The time now is 05:26 PM.