empty cells

[Perry Diels]

Hi All,

I have an Excel workbook with multiple sheets. On sheet 2 I refer to a cell
of sheet 1 like this:

=Sheet1!B2

This works fine of course, but my question is, if the referenced cell in
sheet 1 is empty I don't want a 0 to appear on the target cell in Sheet2.
What's the formula for that?

Thanks in advance,
Perry

 

[Gord Dibben]

Perry

Either turn off zeros in Tools>Options>View, which is a worksheet setting(not
workbook) or enter a formula like

=IF(Sheet1!B2="","",Sheet1!B2)

Gord Dibben Excel MVP

 

[RWN]

=if(Sheet1!B2=0,"",Sheet1!B2)