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