Supress, Hide or Remove #DIV/0!禁止，隐藏或删除＃除法/ 0 ！ Error in Microsoft Office Excel错误在Microsoft Office Excel
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.在Microsoft Excel或Microsoft Office Excel试算表程式，当值除以零（ 0 ）或空白单元格中的公式，细胞，显示的结果会显示错误值＃除法/ 0 ！由于计算。
The error value may give wrong impression to readers especially when the workbook or worksheet is still in preparation.错误的价值可能会错误印象的读者特别是当工作簿或工作仍在筹备中。 And it’s not a professional or nice look when the same formula is applied to multiple cells by dragging or copying and all these rows or columns return an “#DIV/0!” error value.它不是一个专业或好期待时，同样的公式适用于多种细胞通过拖动或复制及所有这些行或列返回一个“ ＃除法/ 0 ！ ”错误的价值。
The error value is valid though, as it’s impossible to divide any value with 0.错误的价值虽然是有效的，因为它是不可能的鸿沟任何值为0 。 However, it’s possible to suppress, hide or remove the #DIV/0!然而，它可能压制，隐藏或删除＃除法/ 0 ！ error value in the cell for unsupported or invalid division formula by using IF worksheet function.误差值在细胞不受支持或无效分工公式用中频工作职能。
To suppress #DIV/0 error value or keep #DIV/0!为了制止＃除法/ 0错误值或保持＃除法/ 0 ！ from appearing when there is an error, use the following formula in place of the standard division formula:出现时，是一个错误，请使用下列公式来取代标准的划分公式：
=IF(denominator=0,"",numerator/denominator)
“Numerator” refers to the cell to be divided. “分子”是指细胞分裂。 “Denominator” refers to the cell that is the divisor. “分母”是指细胞，是除数。
For example, for formula of “A1/A2″ (cell A1 devided by cell A2), the formula to enter into the result cell is as below:例如，对于公式“ A1/A2 ” （ A1单元格除以单元格A2 ） ，公式进入细胞的结果如下：
=IF(A2=0,"",A1/A2)
The formula above checks to see if the denominator equals zero (or is blank); if so, a blank cell is displayed.上述公式检查，看看是否分母为零（或为空） ;如果是的话，一个空白单元格显示。 Otherwise, the cell that contains the function will display the result of the formula expression after calculating.否则，细胞包含的功能将显示的结果后，表达公式计算。
Note: To display other information in the cell if the divisor is blank or zero, type the necessary information in the formula where the quotation marks (”") appear. If you want to display text, type it between these quotation marks. If you want to display anything else (values), type it instead of the quotation marks.注：要显示其他信息在细胞中，如果除数是空白或零，输入必要的信息公式中的引号（ “ ” ）出现。如果你想显示文字，输入这些引号。如果您要显示别的（值） ，键入它不是引号。
Another IF worksheet formula that works utilizing the ISERROR condition.另一个中频工作的公式，工程利用ISERROR条件。 The syntax for the formula portion is:的语法部分的公式是：
=IF(ISERROR(numerator/denominator),"",numerator/denominator)
For example,例如，
=IF(ISERROR(A1/A2),"",A1/A2)
Again, to display other information on the cell if the calculation result is erroneous, change the value of the middle parameter (text string requires quotation marks).同样，以显示其他信息的细胞，如果计算结果是错误的，变化的价值中等参数（文本字符串需要引号） 。
After entering the error handling formula as above, users can drag to copy the formula to apply to other cells, and the similar formula will be applied automatically.进入错误处理公式如上，用户可以通过拖动进行复制公式适用于其他细胞，类似的公式将自动适用。
IMPORTANT : This is a machine translated page which is provided "as is" without warranty. 重要说明：这是一台机器翻译网页这是“原样”提供，无保修。 Machine translation may be difficult to understand.机器翻译可能很难理解。 Please refer to请参阅 original English article英文原文的文章 whenever possible.只要有可能。
Share and contribute or get technical support and help at共享和贡献或获得技术支持和帮助 My Digital Life Forums 我的数字生活论坛 . 。
Related Articles相关文章
- Remove and Uninstall Microsoft Office Activation Assistant - Fix Office Must Be Installed Error删除和卸载微软Office激活助理-修正办公室必须安装错误
- The Connected State of Office Add-ins Registered in HKEY_LOCAL_MACHINE Cannot Be Changed Error When Enable or Disable in Office Outlook/Word/Excel 2007连接国的办公室加载项在HKEY_LOCAL_MACHINE注册不能更改错误当启用或停用在Office Outlook /的Word / Excel 2007中
- New Microsoft Office 2007 File Formats and Extensions for Word, Excel and PowerPoint Files新的Microsoft Office 2007文件格式和扩展Word ， Excel和PowerPoint文件
- Export and Save Word or Excel Documents as Acrobat PDF or XPS Files Directly from Microsoft Office 2007 with Add-in出口和保存Word或Excel文件作为的Acrobat PDF或XPS文件直接从微软Office 2007与外接
- Remove Excel Workbook or Worksheet Lost Password for Free删除Excel工作簿或工作忘记密码免费
- Remove and Hide Facebook Ads删除和隐藏Facebook的广告
- How to Disable Recent Documents History in Office 2007 Excel, Word and PowerPoint如何禁用最近的文档历史Office 2007中的Excel ， Word和PowerPoint
- Enable and Turn On AutoRecover in Office Word, Excel and PowerPoint for Unsaved File Discovery启用并自动开启在Office Word ， Excel和PowerPoint为未保存的文件发现
- How to Clear and Delete Recent Documents List in Office 2007 (Word, Excel, PowerPoint)如何清除和删除最近的文件清单在Office 2007 （ Word ， Excel和PowerPoint中）
- How to Hide or Remove Gmail Spam Counter如何隐藏或删除Gmail的垃圾邮件反击
