Excel: Sum series of function calls

I have the following simple function that I need to call n times and sum the result.

10000*((1.01)^n)

I wish to call this 30 times, with n being 1-30, then sum the result. How can I do this in Excel?

Answers


You can use the following array formula.

=SUM(1000*((1.01)^ROW(A1:A30)))

Paste the formula into the formula bar and press Ctrl+Shift+Enter. It doesn't matter where you enter the formula or what the contents of A1:A30 are; the A1:A30 is just a trick to get Excel to iterate through the formula 30 times.


Need Your Help

Compare current time with values in an array true/false

php arrays time

I'd like to define a set of opening hours for a 7 day week. When a visitor visits the web page I'd like to display the current time and day in a specific country (Nevis, Caribbean) and then compare...

Django POST request to my view from Pyres worker - CSRF token

python django django-csrf

I'm using Pyres workers to do some processing of data users enter in a form. Their processing is done by a view on my form, which I make a POST request to, with data including the data to process a...