Results 1 to 11 of 11

Circular Logic Difficulties

Threaded View

  1. #1
    Registered User
    Join Date
    03-04-2025
    Location
    philly PA
    MS-Off Ver
    365
    Posts
    4

    Question Circular Logic Difficulties

    Screenshot 2025-03-04 160654.png
    Screenshot 2025-03-04 161356.png
    Copy1.xlsx

    Hello! I am using a small circular formula in Excel. I have set the cycle limit to 100 attempts, and I need this circular logic for this particular calculation to optimize it.
    It works sometimes, but sometimes it gets stuck like this where call F26 thinks there is an error in cell G28. However, G28 does not have an error in it. Pressing F9 for a general update doesn't resolve this issue.

    If I specifically update cell G28, then both G28 and F26 show an error. Then I can update cell F26 again and get back to the same stuck state. Why does this happen? Is there anything I can do to fix this?

    Here is what I want to happen: Both F26 and G28 should start at their default values. Then, since G28 has a value in it, then F26 will update with the formula 1.1/G28. Then G28 will check F26 and if it is greater than one of the values, it will update. If it updates to a new number, then G26 will re-calculate and F26 will update again until both of them are happy.
    Is there a better way to do this?

    Thanks!
    Last edited by sdfgdfdg; 03-06-2025 at 10:36 AM. Reason: Resolved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Comparing 2 columns then updating and adjusting 2 other colums/updating
    By SteveC2024 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2024, 11:38 AM
  2. Replies: 1
    Last Post: 07-19-2020, 03:51 PM
  3. Replies: 0
    Last Post: 03-20-2014, 10:21 PM
  4. Help with automatic chart updating/auto updating today function
    By Tux2424 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2012, 04:45 PM
  5. [SOLVED] Updating values in an excel file with data from multiple excel files
    By ScarfaceLex in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 07-17-2012, 02:37 PM
  6. Adding files to existing Excel dataset, updating Excel data set
    By fdavidwest in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2012, 07:13 PM
  7. Replies: 1
    Last Post: 01-31-2011, 07:10 PM

Tags for this Thread

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