ExcelBanter - If statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If statement (https://www.excelbanter.com/excel-worksheet-functions/253000-if-statement.html)

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) ?
--
David Biddulph

"NEHicks" wrote in message
...
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.

That was what I came up with, but was hoping there was some kind of
formatting that would do this as I didn't want to have to insert that formula
on each line. Thanks for the response.

"David Biddulph" wrote:

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

"NEHicks" wrote in message
...
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.

.

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.
--
David Biddulph

"NEHicks" wrote in message
...
That was what I came up with, but was hoping there was some kind of
formatting that would do this as I didn't want to have to insert that
formula
on each line. Thanks for the response.

"David Biddulph" wrote:

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

"NEHicks" wrote in message
...
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.

.