+ Reply to Thread
Results 1 to 9 of 9

Setup up a formula for an Interactive solution ?

  1. #1
    Registered User
    Join Date
    03-26-2010
    Location
    PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Setup up a formula for an Interactive solution ?

    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
    Attached Files Attached Files
    Last edited by Concrete_Engineer; 03-27-2010 at 02:48 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Can Excel solve this ?

    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

  3. #3
    Registered User
    Join Date
    03-26-2010
    Location
    PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Can Excel solve this ?

    Quote Originally Posted by shg View Post
    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.
    I have ammended the title
    I hope this is more appropriate
    Please let me know

    Thanks,

    Jim

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Setup up a formula for an Interative solution ?

    Interesting shg.

    Looking forward to seeing your solution.
    I make it 5.50425... , but it took 4secs to crunch.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Setup up a formula for an Interative solution ?

    See attached.
    Attached Files Attached Files

  6. #6
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Setup up a formula for an Interative solution ?

    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.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    03-26-2010
    Location
    PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Setup up a formula for an Interative solution ?

    shg & Marcel:

    Thank you.
    You guys are good ---- very good.

    Jim

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Setup up a formula for an Interative solution ?

    Quote Originally Posted by Marcol
    but it took 4secs to crunch.
    Curious; Solver does it for me instantly.

  9. #9
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Setup up a formula for an Interative solution ?

    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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1