Calculate terms in a Series

Hi can someone tell me how to set this up? Thank you.
Calculate the next 3 terms in the series 1/4 +1/9+1/14+1/19+...
--
Barbara

Not sure what you want to show in the cells, but assuming the 1st term, 1/4 is
in A1, and you want 1/9 in A2, 1/14 in A3, etc, in A2 put this formula and
copy it down. =1/(1/A1+5). You can format with a Fraction format to show as
1/4, 1/9, 1/14, etc.



On Sun, 2 Oct 2005 19:09:01 -0700, "BarbV"
<[email protected].(donotspam)> wrote:

>Hi can someone tell me how to set this up? Thank you.
>Calculate the next 3 terms in the series 1/4 +1/9+1/14+1/19+...

Another formula that will work and doesn't require putting 1/4 in the top cell
is the following, in row 1 of any column:

=1/(ROW()*5-1)


On Sun, 02 Oct 2005 22:01:24 -0500, Myrna Larson
<[email protected]> wrote:

>Not sure what you want to show in the cells, but assuming the 1st term, 1/4
is
>in A1, and you want 1/9 in A2, 1/14 in A3, etc, in A2 put this formula and
>copy it down. =1/(1/A1+5). You can format with a Fraction format to show as
>1/4, 1/9, 1/14, etc.
>
>
>
>On Sun, 2 Oct 2005 19:09:01 -0700, "BarbV"
><[email protected].(donotspam)> wrote:
>
>>Hi can someone tell me how to set this up? Thank you.
>>Calculate the next 3 terms in the series 1/4 +1/9+1/14+1/19+...

If you question is how to do a summation in Excel, Myrna has given you
an answer. If instead you are wanting help identifying the particular
sequence that you are summing,
http://www.research.att.com/~njas/sequences/
is the standard tool. There are a number of possibilities for the next
term in 4,9,14,19, depending on the mechanism for generating the first
four terms.

Jerry

BarbV wrote:

> Hi can someone tell me how to set this up? Thank you.
> Calculate the next 3 terms in the series 1/4 +1/9+1/14+1/19+...

Thank you for your help.
--
Barbara


"Myrna Larson" wrote:

> Not sure what you want to show in the cells, but assuming the 1st term, 1/4 is
> in A1, and you want 1/9 in A2, 1/14 in A3, etc, in A2 put this formula and
> copy it down. =1/(1/A1+5). You can format with a Fraction format to show as
> 1/4, 1/9, 1/14, etc.
>
>
>
> On Sun, 2 Oct 2005 19:09:01 -0700, "BarbV"
> <[email protected].(donotspam)> wrote:
>
> >Hi can someone tell me how to set this up? Thank you.
> >Calculate the next 3 terms in the series 1/4 +1/9+1/14+1/19+...
>

Thanks for your help and the website.
--
Barbara


"Jerry W. Lewis" wrote:

> If you question is how to do a summation in Excel, Myrna has given you
> an answer. If instead you are wanting help identifying the particular
> sequence that you are summing,
> http://www.research.att.com/~njas/sequences/
> is the standard tool. There are a number of possibilities for the next
> term in 4,9,14,19, depending on the mechanism for generating the first
> four terms.
>
> Jerry
>
> BarbV wrote:
>
> > Hi can someone tell me how to set this up? Thank you.
> > Calculate the next 3 terms in the series 1/4 +1/9+1/14+1/19+...
>
>