Google Sheets: Perform a running formula in the same column-CodePudding

Home > Net > Google Sheets: Perform a running formula in the same column

Google Sheets: Perform a running formula in the same column

Time：04-24

I have a simple formula I want to perform in the same column.

CodePudding user response：

=arrayformula( B1 * (1 - C1) ^ sequence(count(A2:A)) )