Results 1 to 3 of 3

Thread: How to multiply two columns in Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    59

    How to multiply two columns in Excel

    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. #2
    Join Date
    Jun 2011
    Posts
    635

    Re: How to multiply two columns in Excel

    You can use a formula: =a2*b2 and fill down that column. Or =a2*0.2 , may this will help you out.

  3. #3
    rockywhatson Guest

    Re: How to multiply two columns in Excel

    Just follow some steps for doing this, =(first column*second column) and than press enter, this is a proper way of doing this, after writing this you can drag and drop and get the answer of other columns too.

Similar Threads

  1. How to divide two different columns data in Excel
    By Chini mao in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 06:47 PM
  2. Replies: 1
    Last Post: 07-01-2012, 07:46 PM
  3. How to expand and collapse columns in Excel
    By Asaph in forum Windows Software
    Replies: 5
    Last Post: 31-08-2010, 11:39 PM
  4. Changing rows into columns in excel
    By Gannon in forum Windows Software
    Replies: 5
    Last Post: 25-12-2009, 06:10 PM
  5. Macro to Add Columns in Excel
    By geokilla in forum Windows Software
    Replies: 3
    Last Post: 15-10-2009, 01:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,634,762.30005 seconds with 17 queries