Newton's iteration for multiple rows.

[maistral]

I know the title is somewhat vague, sorry. But yeah, here's the thing.

I'm running multiple Newton's iteration rows for a function poly(x) = a*x^b+c*x+d. I however need it to work for multiple rows;

recalc help.jpg

I don't know how to code it such that the =newton() tag would recalculate it for the values depending on the row. I hope you get what I mean. .-.

Thanks a lot~!

[Pepe Le Mokko]

Perhaps post the sheet and the code instead of a useless picture? Thx

[MrShorty]

You need to pass arguments through the hierarchy of functions rather than accessing information directly from the sheet. You also need to review what "scope of a variable" means. As coded, there are two "instances" of the variable x with different scope -- one x for function poly and one x for function newton, and they will likely have different values.

So --

Please Login or Register  to view this content.

[maistral]

I'm really sorry but I didn't get what you said I'm not really much of a programmer

What I'm after is that if I am to compute for =newton() in cell E2, a = A1, b = B1, c = C1, d = D1; likewise in E2, a = A2, b = B2, c = C2, d = D2

[G e r a r d]

The picture makes not enough sense off what the output should be..
What is the formula that you want to create. Don't use a picture, add a workbook with an example of write out the formula.

[maistral]

newtonrandom.xlsm

I managed to make a Newton's iteration function. I just want that a, b, c, and d to be defined depending on the cells that I wanted.

[G e r a r d]

Modified file to MrShorty means to say....

[maistral]

Thanks. I shall be studying how you did it. :D

[G e r a r d]

If your problem is solved mark tread [SOLVED] (tread tools above first post.
If you think if a post helped you, *Add Reputation.