I don't want blank tp equal zero
 

I have 2 worksheets which we will call sheet1 and sheet2.
When I write =sheet1!a1 in sheet 2, and insert a number in cell a1 of
sheet 1, that number appears in sheet 2. The problem is that when I have
it blank, I get zero in sheet 2. I can I make blank show blank?
Obviuosly I want to get zero if the number I insert is actually zero.


--
lovemark
------------------------------------------------------------------------
lovemark's Profile: http://www.excelforum.com/member.php...o&userid=34611
View this thread: http://www.excelforum.com/showthread...hreadid=543836

I don't want blank tp equal zero
 

Try

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

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"lovemark"
wrote in
message
...

I have 2 worksheets which we will call sheet1 and sheet2.
When I write =sheet1!a1 in sheet 2, and insert a number in
cell a1 of
sheet 1, that number appears in sheet 2. The problem is that
when I have
it blank, I get zero in sheet 2. I can I make blank show blank?
Obviuosly I want to get zero if the number I insert is actually
zero.


--
lovemark
------------------------------------------------------------------------
lovemark's Profile:
http://www.excelforum.com/member.php...o&userid=34611
View this thread:
http://www.excelforum.com/showthread...hreadid=543836

I don't want blank tp equal zero
 

Try this:

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

HTH,
Elkar


"lovemark" wrote:


I have 2 worksheets which we will call sheet1 and sheet2.
When I write =sheet1!a1 in sheet 2, and insert a number in cell a1 of
sheet 1, that number appears in sheet 2. The problem is that when I have
it blank, I get zero in sheet 2. I can I make blank show blank?
Obviuosly I want to get zero if the number I insert is actually zero.


--
lovemark
------------------------------------------------------------------------
lovemark's Profile: http://www.excelforum.com/member.php...o&userid=34611
View this thread: http://www.excelforum.com/showthread...hreadid=543836

I don't want blank tp equal zero
 

=if(sheet1!a1="","",sheet1!a1)



lovemark wrote:

I have 2 worksheets which we will call sheet1 and sheet2.
When I write =sheet1!a1 in sheet 2, and insert a number in cell a1 of
sheet 1, that number appears in sheet 2. The problem is that when I have
it blank, I get zero in sheet 2. I can I make blank show blank?
Obviuosly I want to get zero if the number I insert is actually zero.

--
lovemark
------------------------------------------------------------------------
lovemark's Profile: http://www.excelforum.com/member.php...o&userid=34611
View this thread: http://www.excelforum.com/showthread...hreadid=543836

--

Dave Peterson