LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 104
Default Hiding the error caused by the formula in a cell / column

Hi,

I have a formula in a particular cell which calculates the quality % based
on the numbers entered in another cells. I had included the formula in the
required cell and it is appearing as "#DIV/0!" as error as I have not entered
the data in the reference cells pertaining to the formula.

Is there any way to hide the error symbol in that cell without deleting the
formula?

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When hiding column error messge"Can'nt shift object off sheet" Rajeev Sharma Excel Discussion (Misc queries) 1 September 18th 06 01:27 PM
Error caused by *.xls file WLMPilot Excel Discussion (Misc queries) 0 July 27th 06 03:09 PM
Formula to sum every 4th cell returns #DIV/0! error in some column Brent Excel Worksheet Functions 5 March 16th 06 07:20 PM
Excel Caused Error in VBE6.dll. Excel will Close mikeF New Users to Excel 0 March 3rd 05 02:01 PM
Hiding a formula error Kim Excel Worksheet Functions 2 December 1st 04 01:01 AM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"