Depends upon your regional settings whether ; or , is accepted.


Gord Dibben MS Excel MVP

On Tue, 7 Apr 2009 09:43:01 -0700, gunnarhg
wrote:

It worked with ; in stead of , remember ;;;;;
=IF(ISERROR(existing_formula);0;existing_formul a)

"Pete_UK" wrote:

If you don't want to make use of a separate cell (or column), you can
amend the formula which causes the #REF error as follows:

=IF(ISERROR(existing_formula),0,existing_formula)

Hope this helps.

Pete