#1   Report Post  
Horizon Dude
 
Posts: n/a
Default multiplying columns

I want stuff in column A multiplied by stuff in column B and end up in column
C. I would like to have this done automatically instead of doing it every
time i update my sheet. Any help would be greatly appreciated

  #2   Report Post  
Harald Staff
 
Posts: n/a
Default

You will need a computer with a keyboard, a mouse and a spreadsheet program
installed on it. Write this in cell C1 of a spreadsheet file's worksheet:

=A1*B1

and press the Enter key.
Click on cell C1 again. The lower right corner of the cell will be a small
black square. Put the mouse pointer onto it, hold down the left mousebutton
(or the mousebutton if you have only one) and, while holding, drag the mouse
towards the side of the table where your body is. After two or maybe three
minutes, remove your hand from the mouse. Save the file.

Enter stuff in A and B of this sheet in this file from now on and enjoy the
miracles of modern number crunching.

HTH. Best wishes Harald

"Horizon Dude" skrev i melding
...
I want stuff in column A multiplied by stuff in column B and end up in

column
C. I would like to have this done automatically instead of doing it every
time i update my sheet. Any help would be greatly appreciated



  #3   Report Post  
David Billigmeier
 
Posts: n/a
Default

In C1:

=A1*B1

and drag down to the end of your data.

--
Regards,
Dave


"Horizon Dude" wrote:

I want stuff in column A multiplied by stuff in column B and end up in column
C. I would like to have this done automatically instead of doing it every
time i update my sheet. Any help would be greatly appreciated

  #4   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

select column C, with C1 as the activeCell

go to the formula bar and enter

=A1*B1

then hit Ctrl+enter instead of just enter.

--
Regards,
Tom Ogilvy

"Horizon Dude" wrote in message
...
I want stuff in column A multiplied by stuff in column B and end up in

column
C. I would like to have this done automatically instead of doing it every
time i update my sheet. Any help would be greatly appreciated



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Columns FemIce Excel Discussion (Misc queries) 1 September 28th 05 09:29 AM
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
Hidden Columns in Shared Workbooks Rotary Excel Discussion (Misc queries) 1 July 9th 05 12:28 AM
can't insert columns between columns smooth operator Excel Discussion (Misc queries) 1 May 1st 05 10:53 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"