Results 1 to 9 of 9

Excel Circular Reference Problems

Threaded View

  1. #1
    Registered User
    Join Date
    03-01-2016
    Location
    -
    MS-Off Ver
    Mac Office
    Posts
    8

    Excel Circular Reference Problems

    Hi, I have two columns in excel like this:

    A B
    1 0.5
    1.5 0.5
    2 0.5
    2.5 0.25
    2.75 0.25
    3.00 0.25

    Basically the formula for A is the previous number in the A column + the previous number in the B column at the moment. So taking the first example, A1+B1 = A2 =>1 + 0.5 = 1.5 which is the next number in the A column. Now the values of B are controlled as follows: if 2.3<A, then B = 0.5, and if A>2.3 B = 0.25. The problem is that when the change happens, I want where A = 2.5 to actually be 2.25, not 2.5. How can I do this? If I do something like A2 = A1+B2 I get a circular reference... I don't mind adding other columns to do it, or anything that is required. Please let me know!

    Basically my problem is also complicated because there are further changes letter on as A grows, so everytime a change happens there's a problem
    Last edited by dragon324; 03-18-2016 at 01:20 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Newbie - Circular Reference Troubles
    By southaja in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 03-15-2016, 11:26 AM
  2. Replies: 2
    Last Post: 02-23-2014, 06:06 PM
  3. Replies: 1
    Last Post: 08-21-2007, 07:22 PM
  4. Validation & Circular Reference Problems
    By darqphire in forum Excel General
    Replies: 1
    Last Post: 08-18-2006, 05:30 AM
  5. [SOLVED] Issues with my excel formula as it needs Circular reference - hlp
    By im_not_excelling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-04-2006, 03:25 AM
  6. circular reference (Excel 2000)
    By peaspud in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2005, 02:20 PM
  7. [SOLVED] Having problems with a circular reference and the #VALUE! error
    By celicagt1993 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2005, 03:10 PM

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