geometrical progression
=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
|