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...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.