Excel trial and error facility available in Numbers?

You might try using sliders or steppers to help hone in on the answer. One slider for the most significant bits and one or more to fine tune.

Maximum interest rate for your trial and error in cell B1

Slider 1 with a range of 0-99 in cell B2

Slider 2 with a range of 0-100 in cell B3

Interest rate to test = (B2*100+B3)*B1/10000

With a stepper vs a slider it is easier to get to a specific setting but it is slower to make big leaps in value.

You couls also rewrite this so there would also be a minumim to your range and then ther sliders would give you values in between min and max.

I think most of what you are asking for i think can be accomplished using the included financial formulas and tables.

Look at this list of functions and see if they might help. this wont change the values of other cells, but would assist in the manual calculations.

https://www.apple.com/mac/numbers/compatibility/functions.html

Jason

There is no such facility in Numbers, though it can be done with an Applescript. I remember one from years ago but maybe it was specific to a specific problem, I don't recall exactly. I'm not sure I can find it or if it will still work but I'll look.

The script I was thinking of was for a specific application and was pretty basic in how it iterated to a solution.