Prev: adding hours and minutes
Next: Joining Two formulas with the Help of AND / OR / IF Functions to g
From: SEF on 27 Apr 2010 14:21
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!
From: Luke M on 27 Apr 2010 14:52
You will need to change your formulas from:
=[MyBook.xls]Sheet1!a1

to

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

--
Best Regards,

Luke M
"SEF" <SEF(a)discussions.microsoft.com> wrote in message
news:5F1ECA70-8905-4422-A9E2-5142127090ED(a)microsoft.com...
>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!


From: Gord Dibben on 27 Apr 2010 15:10
See one reply at your earlier posting.

No need to multi-post.


Gord Dibben MS Excel MVP

On Tue, 27 Apr 2010 11:21:01 -0700, SEF <SEF(a)discussions.microsoft.com>
wrote:

>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!

 | 
Pages: 1
Prev: adding hours and minutes
Next: Joining Two formulas with the Help of AND / OR / IF Functions to g