Linking blank cells

  • Thread starter Thread starter --Viewpoint
  • Start date Start date
V

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