result should equal a blank field
 

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?

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?

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?