Article ID: 87299 - View products that this article applies to.
This article was previously published under Q87299
In Microsoft Excel, you can prevent error values (such as #N/A, #VALUE!, #REF!, and #NUM!) from being displayed.
To suppress error values, use either of the following methods.
Method 1: Use an IF StatementUse the following IF statement
=IF(ISERROR(formula),"",formula)where formula is the formula for which you want to suppress the error value. If formula returns an error, this statement returns "" (a null character); otherwise it returns the result of formula.
NOTE: There is no space between the quotation marks.
Method 2: Hide the Error Value with FormattingUse a combination of colors and custom formats to "hide" the error value. To make error values invisible, use the background color for everything in the selected cells except numbers. To do this, follow these steps:
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/288972/EN-US/ )XL2002: How to Suppress the Printing of Errors in Workbook Cells