math calculation

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

I have never used Excel before.

Is it possible to assign a value to a column so that it performs a
mathematical calculation on another column?

For instance: I would like column G to be triple the value of column A.

Thanks

q
 
LOL - The amazement you'll have as you learn what it really is capable of.

In G1 put =A1*3

If you have a range of values, eg A1:A20, then put that formula in cell G1,
then copy cell G1, select the range G2:G20 and paste and it will
automatically fill in the correct formulas for you.

Excel is capable of extremely complex math calcs, formulas, logic problems
etc etc

Regards
Ken.........................
 
Thanks

I managed to do the first part, but failed when I got to the 'select the
range...' ould you explain that part a bit more, please?

Thank you very much

JB
 
To select a range, simply click on a cell and then holding down the left
mouse button (assuming you are right handed) drag the cursor across the
range you want and then let go of the mouse. The range should now all be
highlighted. Now you can simply do Edit / Paste from the menu and it will
paste that formula, but with all the rows incremented appropriately, into
every cell in that range

Regards
Ken....................
 
Sorry, it does not work with me

When I try to select the range by holding down the right mouse button, the
selected area comes up with a trembling tiny wavy line andwhen I press the
left button to try and paste, there is no meny to choose from.

I must be doing somethng wrong.

JB
 
Hi JB
Have a look at youtube, it's full of videos for XL.
The link below will bring you to a list of
Microsoft Excel Tutorial for Beginners #1 - Overview
HTH
John
 
I got it! Thanks.

But... I have two sets of columns A,B,C,D and M,N,O,P

Howdo I move the latter closer to the former, so that I end up with abcd and
then hijk?

JB
 
I got it! Thanks.

But... I have two sets of columns A,B,C,D and M,N,O,P

Howdo I move the latter closer to the former, so that I end up with abcd and
then hijk?
Click to expand...

Use your mouse and click on the rectangle that has the letter "E" in
it. The entire column will highlight. While it is highlighted, right
click and select Delete. Column E will be gone and all the higher
lettered columns will shift to the left. You can either do that
repeatedly until M gets close to D, or you can highlight more than one
column at a time (standard windows methods of highlighting multiple
objects - hold the shift key down and drag the mouse) before right
clicking.
 
Sorry, was working pretty late last night - Glad you got your answers.

Regards
Ken......................
 
Back
Top