result should equal a blank field

  • Thread starter Thread starter John M.
  • Start date Start date
J

John M.

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?
 
try this

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

HTH
--
If this posting was helpful, please click on the Yes button

Thank You

cheers,
 
Back
Top