Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
Hello All,
I am running my program for a few thousand cases. Unfortunately when one case has error, the program stops on that case. How can I address the program to jump over the erroneous cases and continue the calculation?
Another question: is it possible to find out about the progression, for example how many cases has been left or required time estimation?
Thank you.
Solved! Go to Solution.
Please post a worksheet.
From your description the 'onerror' function might work.
Please post a worksheet.
From your description the 'onerror' function might work.
You sure would have to be more precise about the nature of the "program" you are running.
In general the approach would be to protect a critical calculation which could throw an error by the "on error" command (or "try" in Prime) which could return a string or NaN in case the calculation fails. This return value them can be used in a conditional branch.