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!
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 ModeratorClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.
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.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |