If statement

[NEHicks]

Is there a way to copy a page to a roll-up worksheet that, when you link it,
any blank cell will stay blank instead of showing 0? I have tried the IF
statement but, when you copy the link, the formula is replaced.

 

[David Biddulph]

I'm not quite sure what you're saying, but what about
=IF(Sheet1!A1="","",Sheet1!A1) ?

 

[David Biddulph]

You could format the cells either to show blanks instead of zeroes (such as)
General;-General;
or conditional format to use font white (or background colour) if the value
is zero,
but neither of those will distinguish a zero from a blank source cell.