Need linked cell to be blank not 0

[amquintero]

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]

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]

That worked perfectly. Thank you so much!

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.