If statement

  • Thread starter Thread starter NEHicks
  • Start date Start date
N

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.
 
I'm not quite sure what you're saying, but what about
=IF(Sheet1!A1="","",Sheet1!A1) ?
 
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.
 
Back
Top