Multiply a number by previous cell and different column-CodePudding

I wish to know if it is possible to multiply column(A) by column(B) and then keep on multiplying the last column(A) result by column(B), in a fast way instead of doing it manually that is. For example:

A1 =200
B2 =0.8
A1*B2 =160
A2 = A1(result) * B2 = 128
A3 = A2 * B2 = 102.4
A4 = A3 * B2 = 81.92

Etc...

CodePudding user response：

You can use exponents to make the dynamic formula you describe based on the row. So if you put this in cell A2 and it would do what you describe, and then just drag down:

=$A$1*($B$2)^row()

Example on

CodePudding user response：

You can use:

=SCAN(200,SEQUENCE(4),LAMBDA(a,b,a*0.8))

Note that you can use references for both 200 and 0.8.