Worksheet Cell Reference

[DavidS]

I have a reference to a cell in another worksheet, same workbook. When the
value in the referenced cell is blank it returns a "0" value. However, I want
the returned value to simply leave as a blank cell. Any advice?
David

 

[John]

Hi David
Something like this : =IF(Sheet1!A1="","",Sheet1!A1)
HTH
John