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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
VLOOKUP worksheet function returns zero for empty cells 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
linked workbook cell returns 0 is source workbook cell is blank? 4
Link to an empty cell question. 2
Linking sheets how do I display the zeros (0) as blank cells 1
Excel If statement that is supposed to return a "" instead returns a 0 1
formulas that may sometimes contain empty cells 2

Back
Top