Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. 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.
