Cell reference displays 0 instead of blank

  • Thread starter Thread starter David Lipetz
  • Start date Start date
D

David Lipetz

In a multi-sheet workbook, if I reference a cell in another sheet (using
=SheetName!Cell) that is blank, the result displays as a 0 (zero).

If the cell being referenced is indeed blank, I need the value returned to
be blank as well. I know I can turn off display of zero values globally for
the sheet, but I'd rather not go that route.

Ideas?

Thanks,
David
 
Thanks.

About 30 seconds after I posted this I realized that was solution. I
actually used:
=IF(ISBLANK(Sheet2!A5=0),"",Sheet2!A5)
 
You may want to test that one more.

David said:
Thanks.

About 30 seconds after I posted this I realized that was solution. I
actually used:
=IF(ISBLANK(Sheet2!A5=0),"",Sheet2!A5)
Click to expand...
 
Back
Top