How would one sum up percentages (in excel), but that they increase as they go?

For instance. I have a table of percentage increase

So 1D coloumn should not be a 10% increase in the TOTAL down, but more. It should be around 12% increase (by my estimate).

Example: 5% > X 5% 3% > 105% 3% (3% out of a now new number which is 105% and not the initial 100%) ....

So I want to see the Increases as they are shown in the table: 5%, 3%, 2% But the sum should reflect the additions.

CodePudding user response：

You can use FVSCHEDULE function to calculate growing percentage:

=FVSCHEDULE(100;A2:A12)/100-1