If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiply two columns in Excel or one column by one number
I am a beginner at this. Using Excel, all I want to do is to multiply 2
columns together to give a third column. For example, a list of numbers in column A against a list of numbers in column B to produce a column C - (A2 times B2 to equal a number C2)) or to multiply all the numbers in one column (like "calories" or A2-A18) times one number (like 0.2) to produce a third column. I tried to do this but the results replaced the numbers. and to multiply one column times two other numbers. I'm going nuts (I'm swearing all over and I don't usually swear) trying to add numbers for a book I'm writing. I've got macronutrients like protein and I want to figure out how many calories the protein is by multiply the number of calories (in column A) times 0.20 I would do this by calculator but I've got about a zillion numbers and last time I tried it I made too many mistakes. Thanks to anyone who can help. |
#2
|
|||
|
|||
Multiply two columns in Excel or one column by one number
You can use a formula:
=a2*b2 and fill down that column. or =a2*0.2 There are instructions at Debra Dalgleish's site for how to fill a range. http://contextures.com/xlDataEntry01.html Axia's Mom wrote: I am a beginner at this. Using Excel, all I want to do is to multiply 2 columns together to give a third column. For example, a list of numbers in column A against a list of numbers in column B to produce a column C - (A2 times B2 to equal a number C2)) or to multiply all the numbers in one column (like "calories" or A2-A18) times one number (like 0.2) to produce a third column. I tried to do this but the results replaced the numbers. and to multiply one column times two other numbers. I'm going nuts (I'm swearing all over and I don't usually swear) trying to add numbers for a book I'm writing. I've got macronutrients like protein and I want to figure out how many calories the protein is by multiply the number of calories (in column A) times 0.20 I would do this by calculator but I've got about a zillion numbers and last time I tried it I made too many mistakes. Thanks to anyone who can help. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Microsoft Access Limits (file size, table records, users) | Mike | General Discussion | 4 | November 4th, 2005 03:01 AM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
creating a bar graph | Johnfli | General Discussion | 0 | October 26th, 2005 08:16 PM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Running total w/2 columns - Excel | RagDyeR | Worksheet Functions | 2 | August 10th, 2005 04:28 PM |