Go Back   TechArena Community > Software > Tips & Tweaks
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 04-11-2008
Member
 
Join Date: Nov 2008
Posts: 47
How to Supress, Hide or Remove #DIV/0! Error in Microsoft Office Excel

Hi Fenton here,
I am regular user of Excel just recently I upgraded to Microsoft office Excel 2007.but In Microsoft Excel or Microsoft Office Excel spreadsheet program, when a value is divided by zero (0) or a blank cell in the formula, the cell that displays the result will show the error value #DIV/0! as the result of the calculation. I don't know why an updated latest version of Microsoft excel is doing this although I didn't have any problem when I tried this in Ms office excel 2003. Can anybody tell me why this happen. Thanks in advance.
Reply With Quote
  #2  
Old 04-11-2008
Member
 
Join Date: Jan 2008
Posts: 242
Re: How to Supress, Hide or Remove #DIV/0! Error in Microsoft Office Excel

Excel displays the #DIV/0! error when a number is divided either by zero (0) or by a cell that contains no value.

Symptom
Excel displays the #DIV/0! error in one or more cells on a worksheet.

Causes
  • Entering a formula that performs explicit division by zero (0) — for example, =5/0.
  • Using a reference to a blank cell or to a cell that contains zero as the divisor in a formula or function that performs division.
  • Running a macro that uses a function or a formula that returns the #DIV/0! error


Resolution
  • Make sure that the divisor in the function or formula is not zero (0) or blank.
  • Change the cell reference in the formula to another cell that does not contain a zero or a blank value.
  • Enter the value #N/A in the cell that is referenced as the divisor in the formula.
  • Entering #N/A will change the result of the formula to #N/A from #DIV/0! to indicate that the divisor value is not available.
  • Prevent the error value from being displayed by using the IF worksheet function. You can then display 0 or any string as the result.

Hope it helps you.
Reply With Quote
  #3  
Old 04-11-2008
Member
 
Join Date: Nov 2008
Posts: 47
Re: How to Supress, Hide or Remove #DIV/0! Error in Microsoft Office Excel

thanks effren for your simple solution its really help.
Reply With Quote
Reply

  TechArena Community > Software > Tips & Tweaks
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Supress, Hide or Remove #DIV/0! Error in Microsoft Office Excel"
Thread Thread Starter Forum Replies Last Post
How to hide status bar in Microsoft Excel 2007 Aza MS Office Support 2 21-02-2012 02:21 PM
VBA to hide the rows in Microsoft Excel Lanka Boy MS Office Support 1 14-01-2012 03:12 PM
Microsoft Office Excel cannot create or use the data range reference because it is too complex Error Finian-- MS Office Support 4 31-12-2011 06:11 PM
Error in the Microsoft Office Excel previewer Althea Windows Software 5 28-04-2011 05:56 AM
Microsoft Office Excel 2003 collioure_bee Windows Software 2 12-10-2009 06:05 PM


All times are GMT +5.5. The time now is 11:35 PM.