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