Hi there , i've a question , how can i do a geometrical or arithmetical
progression in one function at one cell in excel as example
this series ˆ‘_(i=0)^n–’〖xi〗^2 ˆ¶xi=x(i-1)+ 1

and other similar series and that function request x when i = o and n
and thanks

Assume you want to add up

5/1! +( 5^2)/2! + (5^3)/3! + (5^4)/4!

use

=SUMPRODUCT(5^(ROW(1:4))/FACT(ROW(1:4)))

follow evaluate formula and watch how the calculation works - that will help

Modify to suit your needs
--
Wag more, bark less


"arithmatical and geometrical series" wrote:

Hi there , i've a question , how can i do a geometrical or arithmetical
progression in one function at one cell in excel as example
this series ˆ‘_(i=0)^n–’〖xi〗^2 ˆ¶xi=x(i-1)+ 1

and other similar series and that function request x when i = o and n
and thanks

=SUMPRODUCT(5^(ROW(1:4))/FACT(ROW(1:4)))

Hi. This returns 64.375

Ont sure if that's what the op wants, but just to mention one of a few
other ways for the above ...

=SERIESSUM(5,1,1,1/FACT(ROW(1:4)))
'or
=SERIESSUM(5,1,1,1/{1,2,6,24})

also returns 64.375

= = = = =
HTH
Dana DeLouis


On 3/17/2010 11:41 AM, Brad wrote:
Assume you want to add up

5/1! +( 5^2)/2! + (5^3)/3! + (5^4)/4!

use

=SUMPRODUCT(5^(ROW(1:4))/FACT(ROW(1:4)))

follow evaluate formula and watch how the calculation works - that will help

Modify to suit your needs