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 A2A18) 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. 
Ads 
#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 A2A18) > 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 
Need to Improve Code Copying/Pasting Between Workbooks  David  Excel Discussion (Misc queries)  1  January 6th 06 04:56 AM 
creating a bar graph  Johnfli  Excel Discussion (Misc queries)  0  October 26th 05 08:16 PM 
Running total w/2 columns  Excel  Anna / Ideal  Excel Worksheet Functions  14  August 10th 05 04:28 PM 
Arithmetical Mode of Criteria in Multiple NonAdjacent columns  Sam via OfficeKB.com  Excel Worksheet Functions  4  July 14th 05 09:15 PM 
Return Count for LAST NonBlank Cell in each Row  Sam via OfficeKB.com  Excel Worksheet Functions  12  April 17th 05 10:36 PM 