Home 
Search 
Today's Posts 
#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. 
#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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Need to Improve Code Copying/Pasting Between Workbooks  Excel Discussion (Misc queries)  
creating a bar graph  Excel Discussion (Misc queries)  
Running total w/2 columns  Excel  Excel Worksheet Functions  
Arithmetical Mode of Criteria in Multiple NonAdjacent columns  Excel Worksheet Functions  
Return Count for LAST NonBlank Cell in each Row  Excel Worksheet Functions 