cell auto population - why 0 when source cell is empty?

[David Smithz]

Help,

I'm auto populating a cell from another cell contained within another
worksheet.

However irritatingly, if the source cell contains nothing, it places a 0 in
the destination cell.

How can I stop this?

I'm having to complete a spreadsheet for Monday morning so am having a bit
of a crash course in Excel so help is very much appreciated.

Regards

David

[Toppers]

David,
Will this help?

e.g in B1:

=IF(ISBLANK(A1),"",A1)



"David Smithz" wrote:

> Help,
>
> I'm auto populating a cell from another cell contained within another
> worksheet.
>
> However irritatingly, if the source cell contains nothing, it places a 0 in
> the destination cell.
>
> How can I stop this?
>
> I'm having to complete a spreadsheet for Monday morning so am having a bit
> of a crash course in Excel so help is very much appreciated.
>
> Regards
>
> David
>
>
>

[Ragdyer]

One way:

If you're using something like this on Sheet1:

=Sheet2!A1

Try this:

=IF(Sheet2!A1="","",Sheet2!A1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David Smithz" <[email protected]> wrote in message
news:c%[email protected]...
> Help,
>
> I'm auto populating a cell from another cell contained within another
> worksheet.
>
> However irritatingly, if the source cell contains nothing, it places a 0
in
> the destination cell.
>
> How can I stop this?
>
> I'm having to complete a spreadsheet for Monday morning so am having a bit
> of a crash course in Excel so help is very much appreciated.
>
> Regards
>
> David
>
>

[David Smithz]

"Ragdyer" <[email protected]> wrote in message
news:[email protected]...
> One way:
>
> If you're using something like this on Sheet1:
>
> =Sheet2!A1
>
> Try this:
>
> =IF(Sheet2!A1="","",Sheet2!A1)
>
> --
> HTH,
Seems to of worked a treat. Thanks for that.

David

[Ragdyer]

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David Smithz" <[email protected]> wrote in message
news:[email protected]...
>
> "Ragdyer" <[email protected]> wrote in message
> news:[email protected]...
> > One way:
> >
> > If you're using something like this on Sheet1:
> >
> > =Sheet2!A1
> >
> > Try this:
> >
> > =IF(Sheet2!A1="","",Sheet2!A1)
> >
> > --
> > HTH,
> Seems to of worked a treat. Thanks for that.
>
> David
>
>