simplify procedure to get rid of 0 error values in a spreadsheet

F

Frederic

MS Excel, all versions

The formula to be entered to replace the irritant "0 error" values, for
example in a percentage column, is very complicated. Example:
if(iserror(formula),"-",formula).

In a large spreadsheet, many celles will display these 0 error formulas and
they are very annoying, especially when printing.

Can MS Excel simplify this in a next version or update?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
B

Biff

Can MS Excel simplify this in a next version or update?

They are doing just that. (In the next version)

A new function will be added:

IFERREOR

It will take 2 arguments:

IFERROR(Value, value_if_error)

So, instead of doing something like this:

=IF(ISERROR(A1/B1),"",A1/B1)

You'll be able to simplify it to:

=IFERROR(A1/B1,"")

Back to your problem.......

You can use Page Setup and choose not to print the errors or you can hide
them using Conditional Formatting

Before you print:

Goto File>Page Setup>Sheet tab
Cell errors as.....choose an option from the drop down

Conditional Formatting:

Select the cell(s) in question
Goto Format>Conditionla Formatting
Formula is: =ISERROR(cell_reference)
Set the font color to be the same as the background color

Biff
 
Top