help with excel
in [Design]
|
From: amdx on 15 Jun 2010 12:37 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
From: Tim Williams on 15 Jun 2010 12:43 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 -- Deep Friar: a very philosophical monk. Website: http://webpages.charter.net/dawill/tmoranwms "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 > >
From: Jim Thompson on 15 Jun 2010 12:52 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 > I use Excel rarely, but I vaguely recall that there's a way to do the first (equation) entry in column B, then scroll down one line at a time, and it'll index the entries. RTFM :-) Actually the help in Excel (at least old versions) is pretty good. ...Jim Thompson -- | James E.Thompson, CTO | mens | | Analog Innovations, Inc. | et | | Analog/Mixed-Signal ASIC's and Discrete Systems | manus | | Phoenix, Arizona 85048 Skype: Contacts Only | | | Voice:(480)460-2350 Fax: Available upon request | Brass Rat | | E-mail Icon at http://www.analog-innovations.com | 1962 | The only thing bipartisan in this country is hypocrisy
From: Tim Wescott on 15 Jun 2010 13:02 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). Or in cell B1 put =A1 * 0.7 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>) -- Tim Wescott Control system and signal processing consulting www.wescottdesign.com
From: amdx on 15 Jun 2010 13:37
"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? |