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

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

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

- - How do I hide a formula so it will not show on the spreadsheet? (https://www.excelbanter.com/excel-worksheet-functions/81693-how-do-i-hide-formula-so-will-not-show-spreadsheet.html)

Brenda

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

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

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

One way:

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

In article ,
Brenda 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!

All times are GMT +1. The time now is 11:30 PM.