Linking Cells blank becomes 0

  • Thread starter Thread starter eastrivergraphics
  • Start date Start date
E

eastrivergraphics

I am linking cells from one sheet to another (ex. Sheet1!A4). When
ever the field is blank in Sheet1 it comes up as 0 in Sheet2. Is there
a way to make it so that it with stay blank?

I was thinking some kind of IF statement in the formula, but I am very
new to this.

Any help would be appreciated.
 
=if(sheet1!a4="","",sheet1!a4)

is one way.

I am linking cells from one sheet to another (ex. Sheet1!A4). When
ever the field is blank in Sheet1 it comes up as 0 in Sheet2. Is there
a way to make it so that it with stay blank?

I was thinking some kind of IF statement in the formula, but I am very
new to this.

Any help would be appreciated.
Click to expand...
 
One way, if it suits your application, is to use Tools - Options - View and uncheck "Zero
values."

Your thinking on the IF is right.

=IF(Sheet1!A4<>"", Sheet1!A4, "")
=IF('Sheet 1'!A4<>"", 'Sheet 1'!A4, "")
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Back
Top