worksheet reference displays 0 on blank cell

[lawpoop]

Hello all -

We are working on a spreadsheet that has two worksheets. The second
worksheet has references to cells in the first worksheet. These
references are just supposed to re-display text that are on the first
spreadsheet.

Problem is, the references in the second spreadsheet display a '0'
when they reference a blank cell. We want them just to be blank when
the reference cell is blank. I've done some searching and found a way
to globally turn off the display of 0s in the tools menu, but we have
other numeric formulas where we do want the zeros displayed.

So we just don't want 0s in the cells that are supposed to be text. We
just want either the text or the blank cell. What am I missing?

 

[RagDyeR]

Try this:

=IF(Sheet1!A1="","",Sheet1!A1)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hello all -

We are working on a spreadsheet that has two worksheets. The second
worksheet has references to cells in the first worksheet. These
references are just supposed to re-display text that are on the first
spreadsheet.

Problem is, the references in the second spreadsheet display a '0'
when they reference a blank cell. We want them just to be blank when
the reference cell is blank. I've done some searching and found a way
to globally turn off the display of 0s in the tools menu, but we have
other numeric formulas where we do want the zeros displayed.

So we just don't want 0s in the cells that are supposed to be text. We
just want either the text or the blank cell. What am I missing?

 

[Alan]

Try,
=IF(A1<>0,A1,"")
Regards,
Alan.