empty cells

  • Thread starter Thread starter Perry Diels
  • Start date Start date
P

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
 
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
 
Back
Top