I need an Increase formula (if possible) :)

[emvella]

Hi,

Example I have €100 and I want to add 0.67% each time, that sums €100.67. Then if I add 0.67% again it sums €101.34, etc....

Example I want to reach €1000.

Is it possible to have a spreadsheet to tell me how many times I have to add 0.67% to reach €000? Let's say it tells me 345 times

Then let's say that I have to add 345 times to reach €1000. Is it possible to write down one by one and each time that I write down the number the €100 increases? Example I write 1 and €100 sums up to €100.67, then I write 2, the total €100.67 sums to €101.34, etc....

Thanks

 

[awoohaw]

Are you asking for Future Value Calculation and Goal Seek?

Book1
	A	B
1	PV	-100
2	R	0.67%
3	P	345
4	FV	1,001.21
Sheet1

Cell Formulas
Range	Formula
B4	B4	=FV(B2,B3,0,B1)

 

[Dave Patton]

N.B. Number of periods rounded up +1 since I started the sequence from 0

However, Excel 2013 does not have sequence. You can fill or use formulas for 1 to 344 and achieve the same result.

T202312a.xlsm
	F	G
1	0	100.00
2	1	100.67
3	2	101.34
4	3	102.02
5	4	102.71
6	5	103.40
7	6	104.09
9b

Cell Formulas
Range	Formula
G1:G7	G1	=100*(1+0.0067)^F1

T202312a.xlsm
	A	B		D	E	F
1		Principal		100		100.00
2		Rate		0.0067		100.67
3		FV		1000		101.34
4		Nper		344.82		102.02
5						102.71
6						103.40
9b

Cell Formulas
Range	Formula
F1:F346	F1	=100*(1+0.0067)^SEQUENCE(346,,0)
D4	D4	=NPER(D2,0,-D1,D3,0)
Dynamic array formulas.

 

[emvella]

Thanks for your replies, please in which cells do I paste the cell formulas?

 

[Dave Patton]

The post shows where the formulas were entered.
You can use the cells that you prefer.

N.B. You can paste my example to a clean sheet. Click on the icon below the f(x) in the heading, move to your sheet's cell a1 and paste.

 

[emvella]

Yes that's what I did but it is not showing as yours!

I mean where do I have to paste the ones as below?

 

[awoohaw]

Both of the solutions offered can be copied to a clean sheet using the "copy" icon at the top left of grid intersection (above the 1, and to the left of A).

 

[awoohaw]

View attachment 104120

Yes that's what I did but it is not showing as yours!

I mean where do I have to paste the ones as below?
View attachment 104121

Your version of Excel does not have the SEQUENCE Function, which is why you get the NAME? error.
Your version does have Goal Seek.

But, if you're just looking for the number of periods needed to get to 1000, the NPER function or the GOAL SEEK will answer your question.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: I need an Increase formula (if possible) :)
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Dave Patton]

T202312a.xlsm
	A	B	C	D
1	Principal	1,000.00	0	100.00
2	Rate	5.50%	1	100.67
3	FV	1,002.00	2	101.34
4	Nper	13.26	3	102.02
5			4	102.71
6			5	103.40
7			6	104.09
8			7	104.79
9b

Cell Formulas
Range	Formula
B4	B4	=NPER(B2/365,0,-B1,B3,0)
D1:D8	D1	=100*(1+0.0067)^C1