Linking blank cells

[--Viewpoint]

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?

 

[Gord Dibben]

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