how do I repeat this pattern in excel

[Jdisdichrirxnd]

my phone would not allow me to post my sheet or a screenshot for some reason. I need to add 6.9% of each subsequent cell based on value of previous cell.

Starting Value- 360
Increase - 6.90%

360​

384.84​

411.394​

439.7801​

470.125​

502.5636​

Pls help I just can’t work it out lol

 

[myall_blues]

Assuming 360 is in A1, then in A2 put the formula =A1*1.069 and copy it down.

 

[SanjayGMusafir]

I was thinking there has to be some way. Check this and revert -

Book1
	A	B	C
1	360		360
2	6.90%		384.84
3	20		411.39396
4			439.780143
5			470.124973
6			502.563596
7			537.240484
8			574.310078
9			613.937473
10			656.299159
11			701.583801
12			749.993083
13			801.742606
14			857.062846
15			916.200182
16			979.417995
17			1046.99784
18			1119.24069
19			1196.46829
20			1279.02461
21			1367.2773
Sheet1

Cell Formulas
Range	Formula
C1	C1	=A1
C2:C21	C2	=A1*((1+A2)^SEQUENCE(A3,,1,1))
Dynamic array formulas.

 

[SanjayGMusafir]

Or better

Book1
	A	B	C	D
1	360		Option 1	Option 2
2	6.9%		360
3	20		384.84	384.84
4			411.39396	411.39396
5			439.780143	439.780143
6			470.124973	470.124973
7			502.563596	502.563596
8			537.240484	537.240484
9			574.310078	574.310078
10			613.937473	613.937473
11			656.299159	656.299159
12			701.583801	701.583801
13			749.993083	749.993083
14			801.742606	801.742606
15			857.062846	857.062846
16			916.200182	916.200182
17			979.417995	979.417995
18			1046.99784	1046.99784
19			1119.24069	1119.24069
20			1196.46829	1196.46829
21			1279.02461	1279.02461
22			1367.2773	1367.2773
Sheet1

Cell Formulas
Range	Formula
C2	C2	=A1
C3:C22	C3	=A1*((1+A2)^SEQUENCE(A3,,1,1))
D3:D22	D3	=FV(A2,SEQUENCE(A3,,1,1),,-A1)
Dynamic array formulas.

 

[Rick Rothstein]

Using @SanjayGMusafir's set-up, and the fact that you are using xl365, this single formula will spill the data you want for whatever number of rows you specify in cell A3...

=SCAN(360,SEQUENCE(A3),LAMBDA(a,x,a*(1+A2*(x>1))))