Excel Question.

[radio1_mike]

I can't figure out how to do this--

Well, I can partially, please follow...


I have an Excel Workbook with data in it, whenever mathematical fxns are carried with data if I get an irrational number or a negative number I get an "!NUM" error. This is fine. I want in these cases to display a "0" not an error msg-- I even know how to do this.

=IF(ISERROR(Formula),0,Formula)

where Formula can be whatever formula is in that cell, say, D3/1000.

But- I have other mathematical fxns going on in different cells that get the same error. Instead of going to each cell and adding the above in; is there a way I can make a rule for the whole workbook that when an !NUM error comes up Excel just spits out a 0???


This would be a great help, if someone could shed some light on it.

Thanks,
Mike

[radio1_mike]

bump for me and for my problem