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.
Solved! Go to Solution.
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.
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,
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.
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.
I believe the following two options would give you what you want:
Thank you very much MjG. It works well now.