Thread: =Sheet1!A1 - with a blank entry!!!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default =Sheet1!A1 - with a blank entry!!!
=if(Sheet1!A1 = "", "", Sheet1!A1)
--
HTH...

Jim Thomlinson


"CP" wrote:

Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print
sheet 2 - however sometimes cell A1 is left blank which is returning a 0
value on sheet2 - how can I have this so its left blank if no value is in
sheet1 a1??
Reply With QuoteReply With Quote