Solved Excel: Find Next Value In Series

DerbyDad03 March 28, 2013 at 11:13:56

First, a posting tip: Since all threads get saved in the archives of this forum, please try to use a Subject Line that is relevant to your question. A Subject Line such as yours will not help anyone find an answer to a similar question. I have edited the Subject Line of your post to be more relevant, based on what I think you are asking for. Feel free to correct me if I made the wrong assumption. DerbyDad03 Office Forum Moderator Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

DerbyDad03 March 28, 2013 at 11:34:34

✔ Best Answer

In order for a formula to find the next value in a series, one must know the relationship between the values. It looks to me like each number is growing by 10% of the previous number. In other words, sort of like 10% compounding interest. A B 1 1000 1000 2 1100 =B1+(B1*0.1) 3 1210 =B2+(B2*0.1) 4 1331 =B3+(B3*0.1) 5 1464.1 =B4+(B4*0.1) Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.