Skip to main content
P
payman1-Visitor
1-Visitor
November 14, 2014
Solved

on error- continue the calculation

  • November 14, 2014
  • 2 replies
  • 1189 views

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.

Best answer by MikeArmstrong

Please post a worksheet.

From your description the 'onerror' function might work.

2 replies

M
MikeArmstrong1-VisitorAnswer
1-Visitor
November 14, 2014

Please post a worksheet.

From your description the 'onerror' function might work.

W
Werner_E25-Diamond I
25-Diamond I
November 14, 2014

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.

    Terms & ConditionsAccessibility statement