Linking blank cells
 

I created a workbook for others to use. The first sheet in the Excel
workbook has general information that I linked to cells on other worksheets.

However, when cells on the general information sheet are blank, a zero
appears in the other worksheets.

What must I do to maintain the link to the general information sheet but
eliminate the zero?

Linking blank cells
 

Either turn off zero values display in Options or trap for blank cell.

I prefer the trap.

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


Gord Dibben MS Excel MVP

On Wed, 3 Feb 2010 14:49:02 -0800, --Viewpoint
wrote:

I created a workbook for others to use. The first sheet in the Excel
workbook has general information that I linked to cells on other worksheets.

However, when cells on the general information sheet are blank, a zero
appears in the other worksheets.

What must I do to maintain the link to the general information sheet but
eliminate the zero?