Thread: How do I hide a formula so it will not show on the spreadsheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default 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!
Reply With QuoteReply With Quote