result should equal a blank field

[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?

 

[Mike H]

Try

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

Mike

 

[xlm]

try this

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

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

Thank You

cheers,