| Author |
How can I hide the results of a formula in a cell for printing?
|
|
|
| I am using a worksheet to summarize data and I have a column that contains
the heading %Relative Percent Difference. This column contains a formula that
uses values from cells that are entered daily. Prior to the input of data
into the cells that the formula uses, the worksheet shows the value #DIV/0!.
I would like to hide that "value" until data is entered into the cells that
make the value useful.
| |
| Kathleen Anderson [MVP - FrontPage] 2006-03-07, 5:51 pm |
| You should be able to get the answer to your question in an Excel newsgroup.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
"Ellen" <Ellen@discussions.microsoft.com> wrote in message
news:79C86940-1B15-42BD-93E5-3CF3E8CF7E11@microsoft.com...
>I am using a worksheet to summarize data and I have a column that contains
> the heading %Relative Percent Difference. This column contains a formula
> that
> uses values from cells that are entered daily. Prior to the input of data
> into the cells that the formula uses, the worksheet shows the value
> #DIV/0!.
> I would like to hide that "value" until data is entered into the cells
> that
> make the value useful.
| |
|
| Where do I find an Excel Newsgroup?
"Ellen" wrote:
> I am using a worksheet to summarize data and I have a column that contains
> the heading %Relative Percent Difference. This column contains a formula that
> uses values from cells that are entered daily. Prior to the input of data
> into the cells that the formula uses, the worksheet shows the value #DIV/0!.
> I would like to hide that "value" until data is entered into the cells that
> make the value useful.
| |
|
|
|
|