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.