result should equal a blank field
try this
=IF(Sheet3!B5,Sheet3!B5,"")
HTH
--
If this posting was helpful, please click on the Yes button
Thank You
cheers,
"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?
|