How to make +'sheet 1'A1 not show up as zero

  • Thread starter Thread starter tarabull
  • Start date Start date
T

tarabull

when there is nothing in the cell A1 on sheet 1, how can i make sheet 2 leave
a blank cell also instead of inserting a "0"?
 
this now makes my file huge - is there any was to do it as to keep it smaller?
 
How many cells did you place the formula into?

Do you need that many?


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Code to format cells on several worksheets 2
Blank Cell Reference, without if statement 4
=Sheet1!A1 - with a blank entry!!! 4
I don't want blank tp equal zero 3
=Sheet!A1 formula alternative 2
cell on sheet 1 equals cell on sheet two 2
Need linked cell to be blank not 0 2
Getting sheet name and info from cell 3

Back
Top