Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! 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.