I don't want blank tp equal zero

[lovemark]

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.

[Chip Pearson]

Try

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

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



"lovemark"
<[email protected]> wrote in
message
news:[email protected]...
>
> 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
>

[Elkar]

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

[Dave Peterson]

=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