ExcelBanter - Need linked cell to be blank not 0

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

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

- - Need linked cell to be blank not 0 (https://www.excelbanter.com/excel-discussion-misc-queries/189695-need-linked-cell-blank-not-0-a.html)

amquintero

Need linked cell to be blank not 0

I am trying to link sheets, if the data in the reference cell in sheet 1 is
blank I would like the corresponding cell in sheet 2 to be blank, currently
it shows zero (0). How di I make it blank?

sb1920alk

Need linked cell to be blank not 0

One way:

If you're referencing A1 from Sheet 1, use =IF(Sheet1!A1<"",Sheet1!A1,"")
instead of =Sheet1!A1.

If you don't care about the values: Tools-Options-View uncheck Zero Values.

"amquintero" wrote:

I am trying to link sheets, if the data in the reference cell in sheet 1 is
blank I would like the corresponding cell in sheet 2 to be blank, currently
it shows zero (0). How di I make it blank?

amquintero

Need linked cell to be blank not 0

That worked perfectly. Thank you so much!

"sb1920alk" wrote:

One way:

If you're referencing A1 from Sheet 1, use =IF(Sheet1!A1<"",Sheet1!A1,"")
instead of =Sheet1!A1.

If you don't care about the values: Tools-Options-View uncheck Zero Values.

"amquintero" wrote:

I am trying to link sheets, if the data in the reference cell in sheet 1 is
blank I would like the corresponding cell in sheet 2 to be blank, currently
it shows zero (0). How di I make it blank?

All times are GMT +1. The time now is 05:17 AM.