linked cells show "0"

  • Thread starter Thread starter Lenny
  • Start date Start date
L

Lenny

I set up links within a number of cells from worksheet 1 to various cells in
worksheet 2. The cells, on worksheet 2, instead of being blank are showing
"0". Is there a way to eliminate the 0 so the cell is blank also?

Regards - Lenny
 
=if(sheet2!a1="","",sheet2!a1)

Just check first.
I set up links within a number of cells from worksheet 1 to various cells in
worksheet 2. The cells, on worksheet 2, instead of being blank are showing
"0". Is there a way to eliminate the 0 so the cell is blank also?

Regards - Lenny
Click to expand...
 
Back
Top