Solved Excel: Find Next Value In Series

March 28, 2013 at 10:48:08
Specs: Windows 7, 2gb
what would be the formula in excel of values like 1000, 1100,1210,1331, in its 5th cell?? I would be glad for the help!

See More: Excel: Find Next Value In Series

Report •

#1
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.


Report •

#2
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.


Report •
Related Solutions


Ask Question