Thread: How to make +'sheet 1'A1 not show up as zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
  
Posts: 117
Default How to make +'sheet 1'A1 not show up as zero
=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"?
Reply With QuoteReply With Quote