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的垃圾郵件反擊
