View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How to make +'sheet 1'A1 not show up as zero

How many cells did you place the formula into?

Do you need that many?


Gord Dibben MS Excel MVP

On Mon, 23 Mar 2009 09:24:01 -0700, tarabull
wrote:

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

"RonaldoOneNil" wrote:

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

"tarabull" wrote:

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"?