WRONG!

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

But Bob already told you that

--
Kind regards,

Niek Otten

"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:upcS9Wd%23FHA.3308@TK2MSFTNGP11.phx.gbl...
> =IF(Sheet1!A1="","",0)
>
> --
> Kind regards,
>
> Niek Otten
>
> "Crazy" <Crazy.1zl18y_1133811900.706@excelforum-nospam.com> wrote in
> message news:Crazy.1zl18y_1133811900.706@excelforum-nospam.com...
>>
>> Hi,
>> I have a workbook where on Sheet 2 I have certain cells =to cells on
>> sheet 1. If those cells are blank on sheet 1, it is showing up as "0"
>> in the cells on sheet 2. I don't want "0", I want blank if the cells
>> are blank in sheet 1. What should I be doing?
>>
>> Thank you from an excel idiot!
>>
>>
>> --
>> Crazy
>> ------------------------------------------------------------------------
>> Crazy's Profile:
>> http://www.excelforum.com/member.php...fo&userid=8251
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=490840
>>
>
>