Skip to main content
1-Visitor
December 5, 2014
Solved

Updating guess value in looped solve block

  • December 5, 2014
  • 3 replies
  • 1303 views

Hi all,

I have a solve block function inside a program. The program iterates through an array, finding a solution for each element in the array. The problem is that the initial guess value does not work for all elements in the array. I would like to be able to use the previously calculated solution as the new guess value for the solve block. Is this possible?

I can't post the whole sheet, but I've attached an extract which hopefully shows what I'm trying to do.

Thanks

Best answer by Werner_E

So why not make the guess value an additional argument of your solve block function?

1.png

3 replies

Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
December 5, 2014

So why not make the guess value an additional argument of your solve block function?

1.png

19-Tanzanite
December 5, 2014

Just pass it to the function as another parameter.

1-Visitor
December 5, 2014

Thanks gents! A rather simple soltution...