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)

 

[Ragdyer]

One way:

If you're using something like this on Sheet1:

=Sheet2!A1

Try this:

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

 

[David Smithz]

One way:

If you're using something like this on Sheet1:

=Sheet2!A1

Try this:

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

Seems to of worked a treat. Thanks for that.

David

 

[Ragdyer]

Appreciate the feed-back.