+ Reply to Thread
Results 1 to 1 of 1

Iterative Calculation Issues

  1. #1
    Registered User
    Join Date
    05-26-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    15

    Iterative Calculation Issues

    I have a spreadsheet attached. For this sheet, iterative calculations have been turned on, max iteration at 100, max change at .01

    In this spreadsheet, I need to enter a formula to cell G11. The formula will be F11 + C15. When I enter this formula, I am expecting a result of 35,555,556. Instead, cell F11 changes from 25,555,556 to 27,777,778 and that is the result shown in G11 as well.

    My brain has begun to throb from trying to map the circular logic in an effort to circumvent it. I really need another brain/pair of eyes to advise me!
    Attached Files Attached Files

+ 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