I am looking to use excel to constantly do additions.
E.g. Using Blocks c1 and c2 as an example.
If I keyed in number 3 in c1 I want c2 to show the sum of number (50000×97% + 50000×97%^2 + 50000×97%^3).
And if I keyed in 2 in c1 , c2 should show (50000×97% + 50000×97%^2)
Is it possible to key in a formula that allows me to do an addition in conjunction with a power continually?