How do I stop "0" appearing when the linked cell is blank?
C Chip Pearson Apr 7, 2005 #2 Jay, Write your formula like the following: =IF(Sheet2!A1="","",Sheet2!A1)