Can excel solve this equation?
I have a fairly complex equation that needs to be solved with an interative solution.
Can Excel do this ?
File is attached
Any help would be greatly appreciated
Jim
Can excel solve this equation?
I have a fairly complex equation that needs to be solved with an interative solution.
Can Excel do this ?
File is attached
Any help would be greatly appreciated
Jim
Last edited by Concrete_Engineer; 03-27-2010 at 02:48 PM.
Welcome to the forum.
The answer is yes, Excel can do it (x = 5.50426...)
Please take a few minutes to read the forum rules, and then amend your thread title accordingly, then we can discuss how.
Entia non sunt multiplicanda sine necessitate
Interesting shg.
Looking forward to seeing your solution.
I make it 5.50425... , but it took 4secs to crunch.
See attached.
Good one shg
I tried running through Excel but it was pretty slow.
Then the VBa route, it's instant
Please Login or Register to view this content.
shg & Marcel:
Thank you.
You guys are good ---- very good.
Jim
Curious; Solver does it for me instantly.Originally Posted by Marcol
Shg
Originally Posted by Marcol ..........
.........but it took 4secs to crunch............
......... tried running through Excel but it was pretty slow
Sorry a mjsunderstanding. In both cases I meant my attempts in Excel using a combination of formulae and VBa ------ Not Solver.
I haven't used Solver as yet, obviously the sooner I do, the better!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks