Excel question | xltronic messageboard
 
You are not logged in!

F.A.Q
Log in
Register
  
 
  
 
Now online (2)
recycle
Roger Wilco
...and 526 guests

Last 5 registered
Oplandisks
nothingstar
N_loop
yipe
foxtrotromeo

Browse members...
  
 
Members 8025
Messages 2614206
Today 10
Topics 127548
  
 
Messageboard index
Excel question
 

offline TonyFish from the realm of our dreams on 2003-05-15 04:54 [#00699034]
Points: 3349 Status: Lurker



Hi, anyone know Excel?
I have a column full of data and I want to subtract a number
from each cell, square the result and the sum all of the
resulting cells.
I made a new column which is =(C2-12)*(C2-12)
then I took the first cell of the next column and made it
=SUM(C2:C555)
Is there a way I can do this in one step rather than two?

Mille Mercis :)

 

offline pOgO from behind your belly button fluff on 2003-05-15 05:38 [#00699072]
Points: 12687 Status: Lurker



I don't know that, but I do know this:

1. On a new Worksheet, Press F5
2. Type X97:L97 and hit enter
3. Press the tab key
4. Hold Ctrl-Shift
5. Click on the Chart Wizard toolbar button
6. Use mouse to fly around - Right button forward/ Left
button reverse



 

offline Junktion from Northern Jutland (Denmark) on 2003-05-15 05:56 [#00699081]
Points: 9713 Status: Lurker | Followup to TonyFish: #00699034



i'm not quite sure what you mean there, but when i'm making
stuff in excel, and I need one column copyed to the next
including the the values that fit to the next column, I just
click, copy and drag a line in the row and paste


 

offline Bob Mcbob on 2003-05-15 06:55 [#00699148]
Points: 9939 Status: Regular | Followup to Junktion: #00699081



im not sure what you mean mr steven hawking, but when i look
at the stars i use a nice big telescope so i can see lots of
them and perhaps one of those colourful wobbly space
thingies too...

:)

 

Messageboard index