How do I hide a formula so it will not show on the spreadsheet?

[Brenda]

Have 3 columns on my spreadsheet. The third has a formula for figuring the
percentage of the second column to the first one. I have forgotten how to
keep the symbols from showing on my spreadsheet, until a calculation is
entered. Shows#DIV/0!

[JE McGimpsey]

One way:

=IF(A1=0,"",B1/A1)

In article <[email protected]>,
Brenda <[email protected]> wrote:

> Have 3 columns on my spreadsheet. The third has a formula for figuring the
> percentage of the second column to the first one. I have forgotten how to
> keep the symbols from showing on my spreadsheet, until a calculation is
> entered. Shows#DIV/0!