Guntars,

Create your own UDF to use in XL 2003. Here is a rough example below:



Function IfIsError(pvarResult As Variant, pvarValueIfError As Variant) As
Variant
'Public Function IfIsError(pvarResult As Variant, pvarValueIfError As
Variant) As Variant
'Private Function IfIsError(pvarResult As Variant, pvarValueIfError As
Variant) As Variant

If Application.WorksheetFunction.IsErr(pvarResult) Then
' If Application.WorksheetFunction.IsError(pvarResult) Then
' If Application.WorksheetFunction.IsLogical(pvarResult ) Then
' If Application.WorksheetFunction.IsNA(pvarResult) Then
' If Application.WorksheetFunction.IsNonText(pvarResult ) Then
' If Application.WorksheetFunction.IsNumber(pvarResult) Then
' If Application.WorksheetFunction.IsText(pvarResult) Then
' If Not IsDate(pvarResult) Then
' If IsArray(pvarResult) Then
' If IsEmpty(pvarResult) Then
' If IsMissing(pvarResult) Then
' If IsNull(pvarResult) Then
IfIsError = pvarValueIfError
Else
IfIsError = pvarResult
End If

End Function



As you can see, I included (but commented out) several different tests so
you can tailor it to your needs. Be sure to use the "NOT" keyword when
necessary, or switch your "If...Then" statement with your "Else"
statement...like I did with "If Not IsDate..."

You would call this in XL by entering a formula like this in a cell:

=IfIsError(A5/0,"Error - Please Fix Something!!!")

HTH,

Conan Kelly




"Guntars" wrote in message
...
Gentlemen,
I created array formula in Excel 2007. It works fine, but after it runs
out
of condition matching results it will display #NUM! error. I can hide that
error with new IFERROR function in Excel 2007, but my problem is the
document
will be used in Excel 2003, and haven't found the way how to hide that
error.
If I do the IF(ISERROR(FORMILA),"",(FORMILA)) it will mess up my formula
results.
<a href="http://www.eonstone.com/250/Attendee checklist .xls"I attached
portion of the file I am working on. </a. The error I can't hide is on
5S_Audit sheet, columns B,C and D.
I need some expert help here, or maybe the formula need to be put together
differently.
Any help and suggestions are highly appreciated.