# 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

#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.DerbyDad03Office 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
 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) ```