How to make +'sheet 1'A1 not show up as zero

[tarabull]

when there is nothing in the cell A1 on sheet 1, how can i make sheet 2 leave
a blank cell also instead of inserting a "0"?

 

[RonaldoOneNil]

=IF('sheet 1'!A1="","",'sheet 1'!A1)

 

[tarabull]

this now makes my file huge - is there any was to do it as to keep it smaller?

 

[Gord Dibben]

How many cells did you place the formula into?

Do you need that many?


Gord Dibben MS Excel MVP