I need to change the #ERROR result in a field

[Juan jaspe]

When I work with a calculated field, sometimes it results with a #error, I
need to evaluate that answer to change to another value, maybe 0 or 1 with a
IIf expresion, equal to NA answer for example.

Regards

 

[JackD]

I do not thing that project offers anything like excel which can evaluate
it.
You need to write your formula so it does not result in an error.

The "NA" problem is discussed and solved here:
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

 

[John]

When I work with a calculated field, sometimes it results with a #error, I
need to evaluate that answer to change to another value, maybe 0 or 1 with a
IIf expresion, equal to NA answer for example.

Regards

Juan,
I don't see a question in your post. There are several reasons you may
get an error with a calculated field. I doubt there is a general formula
that will address that issue in all cases. The particular reason for the
error message must be understood.

John
Project MVP