View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default result should equal a blank field

Try

=IF(Sheet3!B5<"",Sheet3!B5,"")

Mike

"John M." wrote:

I am linking data from a cell on another page in my workbook. Sheet3 cell B5
is presently blank awaiting input. Sheet1 cell A5 I use formula =Sheet3!B5
which produces a result of 0 instead of being left blank until input is
entered into the cell on Sheet3 cell B5. Why is this and how do I make my
result blank until data is entered on the other page?