Cell reference displays 0 instead of blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Lipetz - 24 Oct 2006 19:19 GMT

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

Reply to this Message

Ken Puls - 24 Oct 2006 19:26 GMT

Wrap it in an if statement:

=IF(Sheet2!A5=0,"",Sheet2!A5)

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

> 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).
[quoted text clipped - 7 lines]
> Thanks,
> David

Reply to this Message

David Lipetz - 24 Oct 2006 19:40 GMT

Thanks.

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

> Wrap it in an if statement:
>
[quoted text clipped - 14 lines]
>> Thanks,
>> David

Reply to this Message

Dave Peterson - 24 Oct 2006 19:45 GMT

You may want to test that one more.

> Thanks.
>
[quoted text clipped - 20 lines]
> >> Thanks,
> >> David

Signature

Dave Peterson

Reply to this Message