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.
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.
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.