+ Reply to Thread
Results 1 to 2 of 2

Workaround for a circular reference required

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,683

    Workaround for a circular reference required

    Hi all

    I have a spreadsheet which should balance but doesn’t so therefore I want to lose the balance as the difference is insignificant.

    The problem I have is that this creates a circular reference which I need to find a solution to.

    What is the best way to achieve this? I am open to any ideas but it needs to be automated as much as possible.

    Currently the spreadsheet totals the budget and target rows – if there is a difference between the two I need to lose this in cell G28

    I have attached an example
    Attached Files Attached Files

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,697

    Re: Workaround for a circular reference required

    Have you tested using "Goal Seek"?

    Goto tab "Data"-> "What if Analysis" and click "Goal Seek"

    Based on your uploaded file

    Set cell: G49
    To value: 0
    By changing: G28

    Click "ok" twice

    Alf

+ 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