Hiding #DIV/0! and Other Errors on an Excel Spreadsheet PSS ID Number: Q41621 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

You can hide a #DIV/0 error and other errors on an Excel spreadsheet. For example, suppose you use the following function:

=5/B3

If you use the following function, Excel will show a blank in the cell if an error occurs; otherwise, the value will be displayed:

=IF(ISERROR(5/B3)," ",5/B3)

The ISERROR function checks to see if any error is returned by the calculation. If an error is returned, a blank space is placed in the cell; otherwise, the value of the calculation is returned to the cell.

Reference(s):

“Microsoft Excel for Functions and Macros,” version 2.1, pages 65-66

“Microsoft Excel Function Reference,” version 3.0, pages 135-136

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.