ExcelBanter - How I prevent a "0" when a linked cell is empty?

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

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

- - How I prevent a "0" when a linked cell is empty? (https://www.excelbanter.com/excel-worksheet-functions/161596-how-i-prevent-0-when-linked-cell-empty.html)

Mickyg

How I prevent a "0" when a linked cell is empty?

Linking values from one worksheet to another within the same workbook, an
empty cell in the original returns a value 0. How do I get it to return a
blank cell?

papou[_2_]

How I prevent a "0" when a linked cell is empty?

Hello Mickyg
Try
=IF(Sheet2!A1<"",Sheet2!A1,"")

HTH
Cordially
Pascal

"Mickyg" a écrit dans le message de news:
...
Linking values from one worksheet to another within the same workbook, an
empty cell in the original returns a value 0. How do I get it to return a
blank cell?

All times are GMT +1. The time now is 06:53 AM.