linked cells show "0"

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
 
D

Dave Peterson

=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...
 

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

Copying linked sheet 2
Excel VBA 1
3d reference 5
Leaving a formula cell blank when data has not yet been added. 5
Blank Cell Reference, without if statement 4
Values from referenced cells 6
text as 0 4
Need an alterate result to "0" for null value 1

Top