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

In B2, type =IF(A2<2.3,0.5,0.25) and copy down.

I would think If column B is a variable that changes based on what you put into it and cell A2 is the first number you choose and then the following A3+ cells grow based on what is in column B next to the corresponding cell in A then in cell A2 you would put the formula and copy it down in column A to wherever you want it to stop at.

=A1+B1

This is cell A2
Once you copy it down to A3
The code in A3 should look like

=A2+B2

....
Oh I missed a part nvm.

When I used the formula I provided, it returns the results you have shown in your first post with no circular error. What do you not like about it? Or what is missing? Please clarify your issue.

I've already typed that.

does not help me to help you. Please be more specific.

column A seems straightforward A2=A1+B1.
column B seems to be where the real logic challenges are. Why is 2.3 the comparison? Based on the simple example you have presented, I used if(A2<2.0,0.5,0.25) and that changed B from 0.5 to 0.25 earlier in the sequence -- to where you say you want the change from 0.5 to 0.25 to occur. Or, perhaps, IF(A2+0.5<2.3,0.5,0.25). Where does the 2.3 come from? What kind of scenarios do you expect to need this to work for? I think the solution to the problem lies in carefully defining the "condition" going into the IF function in column B, and I cannot see from this side of the internet exactly what that condition needs to be.

In the interest of others who may have a similar issue, please explain your solution. Also, if this thread is solved, then please mark it as such by

select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.