How to use "on error" in my function.

[mzarrabi]

Hi everybody. I have attached a picture of my function. Does anyone know how to find a way that the while loop goes to the next loop whenever there is an error in the D_M function?  My current way of coding does not work and I cannot find the reason.

[RichardJ]

The format for "on error" is "x  on error y". It evaluates y, and if that gives an error, it returns x instead. That is not what you have. Note that you cannot just type "on error" into a placeholder. You must enter it from the programming toolbar.

[mzarrabi]

Dear Richard,

Thank you for your response. Now, I understand what was the problem. I modified it a little bit. Now there is another problem.  When yj equals to "x.calculations" the function stops as I want, but it does not show "x.calculation" as the last answer.

Best,

[Werner_E]

use

return "x.calculation"

instead of

"x.calculation"

break

Note, that "return" is a command liek "if" or "on error" and you have to chose it from the toolbar and can't simply type it in.

[mzarrabi]

you are right, but if I use "return", the function gives me the last value of y. In fact, I'd like to see previous values of y also.

[MJG · Accepted solution]

I believe the following two options would give you what you want:

[mzarrabi]

Thank you very much MjG. It works well now.