This should be so easy...

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!

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


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

you could
on sheet2 go to
tools
options
view
and uncheck zero values

or you could have a condition in the formula
something like
=if(sheet1!A55=0,"",sheet1!A55)

--
Greetings from New Zealand
Bill K

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

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

--
Kind regards,

Niek Otten

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

Hi!

Try this:

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

Biff

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

WRONG!

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

But Bob already told you that

--
Kind regards,

Niek Otten

"Niek Otten" <[email protected]> wrote in message
news:upcS9Wd%[email protected]...
> =IF(Sheet1!A1="","",0)
>
> --
> Kind regards,
>
> Niek Otten
>
> "Crazy" <[email protected]> wrote in
> message news:[email protected]...
>>
>> 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
>>
>
>

Thank you all so much!