IsError still shows #Div/0

[proballin]

I have an If statement in a text box that does a calculation. This IF statement is enclosed in the IsError function. However whenever there is an Error as opposed to displaying a "1" it says #Div/0 or #Num. Shouldn't it say "1"? When there is no error is says "0".

 

[Rich]

I don't think the IsError function is designed to be used that way

 

[proballin]

I may have misinterpreted the ISError Function...I thought it would return a boolean true if there is an error or a boolean false if there is no error...it seems that when there is an error it just displays the error.

 

[Rich]

I think it's designed for vba, try using the Nz function in your calculation

 

[honda882000]

I believe VBA uses 0 for false and -1 for true.
Is this what you used?:

IFF(IsError([field]/[other_field]),0,[field]/[other_field])