Prev: Hey Larkin? How about something new?
Next: The right box
From: Charlie E. on 15 Jun 2010 13:43
On Tue, 15 Jun 2010 12:37:56 -0500, "amdx" <amdx(a)knology.net> wrote:

>
>"amdx" <amdx(a)knology.net> wrote in message
>news:a8165$4c17abfe$18ec6dd7$32269(a)KNOLOGY.NET...
>>I want to multiply all the numbers in column A by .07 and put the answers
>>in column B.
>> Then add all the numbers in B for total and put that in C1.
>> I am at home but it's not homework.
>> Mike
>Thanks guys, I realized I didn't do what I wanted.
>I have in column A1 thru A39 the SS taxes I paid.
>I want to find the value of A1 compounded at 7% interest
>over 39 years.
>Then A2 compounded at 7% interest over 3 years,
>and A3 compounded at 7% interest over 36 years,
>etc.
> Then I want add them all to find what the total as is if I had
>put all my SS payments into an account earning 7% compounded annually.
> Any help?
>

Mike,
In column A put the year number (39 to 1)
In column B the contributions for that year
In column C the equation for interest on the amount in B for the years
in A
In column D you put the SUM(C1:Cn) equation

Charlie
From: Tim Wescott on 15 Jun 2010 14:28
On 06/15/2010 10:37 AM, amdx wrote:
> "amdx"<amdx(a)knology.net> wrote in message
> news:a8165$4c17abfe$18ec6dd7$32269(a)KNOLOGY.NET...
>> I want to multiply all the numbers in column A by .07 and put the answers
>> in column B.
>> Then add all the numbers in B for total and put that in C1.
>> I am at home but it's not homework.
>> Mike
> Thanks guys, I realized I didn't do what I wanted.
> I have in column A1 thru A39 the SS taxes I paid.
> I want to find the value of A1 compounded at 7% interest
> over 39 years.
> Then A2 compounded at 7% interest over 3 years,
> and A3 compounded at 7% interest over 36 years,
> etc.
> Then I want add them all to find what the total as is if I had
> put all my SS payments into an account earning 7% compounded annually.
> Any help?
>
>

present value this year = 1.07 * present value last year + this year's
contribution.

So, if you have the contributions in column A starting at A1, cell B1
would be '=A1', then cell B2 would be '=1.07 * B1 + A2', and you could
copy cell B2 down through the rest of the sheet.

If you're doing this to be pissed off at the government, you should at
least be fair and keep in mind that an account that earns 7% interest in
a 7% inflation year gains no real value it all -- i.e. you should
depreciate past values by inflation.

--
Tim Wescott
Control system and signal processing consulting
www.wescottdesign.com
From: Archimedes' Lever on 15 Jun 2010 14:57
On Tue, 15 Jun 2010 11:37:10 -0500, "amdx" <amdx(a)knology.net> wrote:

>I want to multiply all the numbers in column A by .07 and put the answers in
>column B.
>Then add all the numbers in B for total and put that in C1.
> I am at home but it's not homework.
> Mike
>
Using column headings named however you desire in A1 B1 and C1, your
final summation result will be in C2. Other than that, it is as you
prescribe.

In the top cell (of data, say "B2") for column B place the formula
(without the quotes):

"=A1*0.07"

In C2 place:

"=SUM(B2:BX)"

Where "X" is replaced by the last row number of your data set.

There is also a way to automatically sum the entire column.

=SUM(B:B)

The latter works just fine.
From: Archimedes' Lever on 15 Jun 2010 14:58
On Tue, 15 Jun 2010 11:43:05 -0500, "Tim Williams"
<tmoranwms(a)charter.net> wrote:

>In B1, enter
>=A1:n*0.07
>
>where n is the number of rows.
>
>In C1, enter
>=SUM(B1:n)
>
>Or just read Excel Help. It's all in there, and usually less trouble than asking online.
>
>Tim

You missed what he meant.

He wants to multiply EACH number in A. Not a running tally of any
kind.
From: Archimedes' Lever on 15 Jun 2010 15:00
On Tue, 15 Jun 2010 10:02:43 -0700, Tim Wescott <tim(a)seemywebsite.now>
wrote:

>On 06/15/2010 09:37 AM, amdx wrote:
>> I want to multiply all the numbers in column A by .07 and put the answers in
>> column B.
>> Then add all the numbers in B for total and put that in C1.
>> I am at home but it's not homework.
>> Mike
>>
>>
>What Tim said (but it doesn't work in OOo).

It doesn't work at all.
>
>Or in cell B1 put
>
>=A1 * 0.7

Except that you are off by an order of magnitude, dude.

>then copy that down for as many entries as you have in A -- it'll
>automatically change the index for the reference to the A column.
>
>Then in C1 put
>
>=sum(B1:B<whatever>)

Or just =SUM(B:B)
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: Hey Larkin? How about something new?
Next: The right box