Skip to main content
1-Visitor
Nov 14, 2014 5:14 PM UTC
Solved

on error- continue the calculation

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.

1-Visitor
Nov 14, 2014 5:36 PM UTC

Please post a worksheet.

From your description the 'onerror' function might work.

2 replies

1-Visitor
Nov 14, 2014 5:36 PM UTC

Please post a worksheet.

From your description the 'onerror' function might work.

Translate
Werner_E
25-Diamond I
Nov 14, 2014 6:08 PM UTC

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.

Translate