Sum Formula

[Danny Danisch]

Dear All,

I am looking for a possibility to calculate the following
function:

Sum (1 to n) of 55-1,23^n

e.g.: for n = 3:

55-1,23^1 + 55-1,23^2 + 55-1,23^3 = 160,39

Is it possible to 'program' such a formula in Excel and
may anyone help me?

Thank you and all Best

Danny Danisch

 

[Jerry W. Lewis]

=SUM(55-1,23^ROW(A1:A3))

array entered (Ctrl-Shift-Enter)

Jerry

 

[Guest]

Thank you!

-----Original Message-----
=SUM(55-1,23^ROW(A1:A3))

array entered (Ctrl-Shift-Enter)

Jerry



.