How to use the IF worksheet function to suppress the #DIV/0!
error value in Excel (291050)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
This article was previously published under Q291050 For a Microsoft Excel 2000 version of this article, see 182188.
SUMMARY
When you divide by 0 (zero) or a blank cell, Microsoft Excel displays
the error value "#DIV/0!" as the result of the calculation. This article
shows you how to use the IF worksheet function to suppress the #DIV/0!
error value.
REFERENCES
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
182189
How to create a conditional format to hide errors in Excel
Modification Type: | Major | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto KB291050 |
---|
|