Ignore Blanks

S

SEF

I have a worksheet that I copy cells from other worksheets. Just a simple
copy/paste/link works great - unless the original cell is blank - and then it
puts a 0% in. I need it to stay blank and not to put any value if blank but
cannot figure out how to do that. I am not trying to sum or concatenate or
any other forumula, simply updating various worksheets in a workbook weekly
and have my master update from all the worksheets. I have over 57000 cells
so I really don't want to have to manually update each cell when it's blank
(not to mention I don't know since I do have valid 0's in some). Any help
is appreciated!
 
L

Luke M

You will need to change your formulas from:
=[MyBook.xls]Sheet1!a1

to

=IF(ISBLANK([MyBook.xls]Sheet1!a1),"",[MyBook.xls]Sheet1!a1)
 
G

Gord Dibben

See one reply at your earlier posting.

No need to multi-post.


Gord Dibben MS Excel MVP
 

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

Top