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 manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History