This should be so easy...

[Crazy]

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!

 

[Bob Phillips]

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

--

HTH

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

 

[Niek Otten]

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

 

[Bill Kuunders]

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)

 

[Biff]

Hi!

Try this:

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

Biff

 

[Niek Otten]

WRONG!

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

But Bob already told you that

 

[Crazy]

Thank you all so much!