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 Moderator

Click 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.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History