Comments on: How to multiply cells in Excel with formula examples

This tutorial shows how to use the multiplication operator in Excel and how to write a formula to multiply cells, columns and rows, numbers and percentages, and more. Continue reading →

Table of contents

Comments page 4. Total comments: 140

  1. Hi all,
    I am looking for a bit of advice. I have created a spreadsheet to calculate the total cost of an order, comparing 3 different companies prices.
    I have a drop down menu to select the type of equipment that we require and have added a sumif formula to automatically input the singular unit value of the selected equipment into the adjacent column. I also have a quantity column, I would like to be able to select the equipment type in the drop down box and have a formula to automatically multiply the unit cost by the quantity and input that value into the cell in place of the singular unit cost.

    For example, I would like to order 5 packs of large gloves. I would select the large gloves in the drop down menu which would automatically input the unit value for 1 pack of gloves via the sumif formula into the next cell. I would then enter the quantity as '5' into the quantity column and I would like the formula to multiply the singular unit cost by 5 and automatically enter the total in place of the singular unit

    Does anyone know how I can do this?

    I hope this makes sense, I am happy to further explain if necessary.

  2. Thank you so much, this was so helpful!!!

  3. Write the formula using appropriate Excel syntax, that you would use in cell B2 which if copied across column B, C, D and E would populate the columns with the multiplication table of 2, 3, 4, 5 and 6

  4. How do you multiply a cell value by the current month ?

    1. Hi Bob,

      Simply return the current month by nesting the TODAY() function inside MONTH, and then multiply by a cell. For example:

      =A2*MONTH(TODAY())

  5. I’m trying to divide column B by column C then multiplying that by column C. Column B is dollars and cents and I would like column D (the final product) to be dollars and cents also. Please help!

  6. Is there a formula out there to multiply x by 5 and have it so I enter in x into the cell then it change to correct amount?

  7. Trying to do a if d1 >2 then d3= d1*25.
    any Ideas?

  8. I need to calculate a 3 time markup for each individual price in a row not a column. For example, A1 through G1 multiplied by 3 times

  9. 3000 X 4 - 3% formula please

  10. Hi,
    Anyone know a formula that can multiple the "A" only? so 5*-3*4.. What if I had lots of As? See below 2 columns
    Thanks,
    A 5
    B 4
    C 2
    D -4
    A -3
    A 4

  11. hOW DO I MULTIPLY THE NUMER OF ROWS BY A NUMBER?

  12. Is there a way to enter a value into a cell then have it automatically calculate to multiply by a certain amount? Meaning: say I have the total square footage of a house (3000) and want to multiply it by 0.09 but have it show in the cell I am putting the 3000 into?

  13. Our problem is that
    How to fit this formula in one cell in excel.
    A1-b1×1000÷545
    Pls help me

  14. I am a beginner in excel in Qty column I want to multiple Qty column with Price each column and put the answer in Cost column

  15. how to multiply 250*250*630 in a cell in excel

  16. I need to multiply mileage at the rate of $.58 per mile. The rate recently changed and looking at the previous rate @ $.545 formula, it makes no sense to me. =round(H2*$AC$1,2) I don't see how this shows a rate of $.545. I need help please

  17. How do I multiply 259 hours and 55 mins by 24 in Excel
    I tried =259:55*24
    But it didn't seem to work

  18. hi is there a way to sum two rows (or columns whatever) from a different sheets, that i want to multiply each other in one step?
    For example sheet one: 5,6,7....43, to multiply by corresponding values in a second sheet 234,348,523, ...12438, then to receive the sum of the multiplied results in a single cell?

  19. Price table
    | a | b | c |
    1|ITEM |17-18|18-19|<--- Financial Year
    2|ABC | 10 | 20 |<--- Unit Price of ABC item
    3|DEF | 20 | 30 |<--- Unit Price of DEF item

    Calculation Table

    | a | b |
    1|ITEM | Qty |
    2|ABC | 1 |
    3|DEF | 2 |
    4|ABC | 3 |
    5|Total| 6 |
    6|17-18| 80 |<---- (1*10+2*20+3*10) result i want
    7|18-19| 140 |<---- (1*20+2*30+3*20) result i want

    how do i get the above result as formula should take unit price from price table based on "item" & "financial year" and multiply the same to calculation table ?

  20. Hi

    I am trying to do a calculation based off the grouping of a third cell.
    i.e. I have 2 cells ID and Amount

    There are 2 rows for each ID number.

    I would like to do a calculation that uses the ID number to find the two amounts and subtract amount one from amount 2.

    example
    ID AMOUNT
    Row1 500 100
    Row2 500 250 This would yield 150

    Thanks is advance for any help.

  21. hi everyone, can u help me on how to calculate if (C3) less than 1000, C3 will times 80cents, onwards value if C3 more than 1000 it will start to calculate c3 times 40 cents. than both value will be sum up

  22. THank you doug!!

  23. Aaron:
    Does =Product(D3:D13) work? If so, does the product of the range D3:F2 make sense for your purposes?
    Is F2 a number you want to multiply the D3:D13 range by? Something like this: =Product(D3:D13,F2)
    This says get the product of the range D3 to D13 and multiply it by the number in F2.
    If F2 is a static number then try:
    =Product(D3:D13,3) or whatever number is in F2.

    1. Hi Doug,

      Thanks for the quick response! What you said here was in the right direction:

      "=Product(D3:D13,F2)
      This says get the product of the range D3 to D13 and multiply it by the number in F2."

      Rather than the product of the range D3 to D13, I'm trying to figure out how to get the sum of the range D3 to D13 and multiply it by the number in F2.

      For some context, F2 is the quantity of units, and D3:D13 are values representing profit amounts. The easy way would be to add a cell somewhere, take A2 for example, that is =SUM(D3:D13) and then doing =PRODUCT (A2,F2) but I'm trying to figure out how I can skip a step.

      Thanks!

      1. Aaron:
        OK, that being the case the formula should be:
        =Sum(D3:D13)*F2
        Does that work for you?

        1. Yes! What if I wanted to multiply the sum of D3:D13 by the product of F2:F5?

          Is there a more efficient way than doing =Sum(D3:D13*(F2*F3*F4*F5)?

          1. Aaron:
            This is where you can use the PRODUCT function.
            It might look like this: =SUM(D3:D13)*PRODUCT(F2:F5)

          2. Thank you so much!

  24. Hi,

    This was a helpful article, thanks! However, I'd like to multiply the sum of values in multiple cells with the value in another cell. For example:

    =PRODUCT(D3+D4+D5+D6+D7+D8+D9+D10+D11+D12+D13,F2) is what I want to do, how would I do this without typing each one out?

    =PRODUCT((=SUM D3:D13),F2) of course does not work. Thanks!

  25. 0.66.7 * 2500 multiply formula .....?

  26. I cant figure this out seems very simple

    A1(10)*A2(10)

    =100

    then times then add 10% to it to equal 110

    tried =(A1*A2)*.1 but it comes up with 10

    1. Marc:
      You have to add the multiplied cell values to the result of the cell you divided.
      =((A1*A2)*0.1)+(A1*A2)

  27. Shipping
    $10.36
    $0.00
    $0.00
    $15.70
    $10.88
    $0.00
    $13.13

    I would like to create a formula that if i enter a number into a column that it would multiply it by a percentage say 15%. So my example is if i enter $15.00 into my shipping column how can i write a formula to multiply that by 15% to get $17.25 in my shipping column?

    1. Dean:
      If price is in A1 then formula in shipping column's cell looks like this:
      =(A1*0.15)+A1
      Be sure to format the A1 and shipping cells as Currency.
      If you ever need to change the percentage you can enter a cell address in the formula in place of the hard-coded "0.15" and modify your shipping cost a little easier.

  28. How to multiply too many cells in one Formula

  29. its great see this kind of tips to learn something

  30. Is it possible to have the value of a cell be a number multiplied by a multiple of another number in a cell?

    For example: C50 = 2 x every multiple of 100 in B50.

    So if B50 was 300, C50 = 600; if B50 was 378, C50 = 600.

    Is there a formula for this?

    Thanks

  31. Pls' halp me.sempal is A(QTY) B(RATE) C(DISCOUNT) D(TEX) E(TOTALVALUE) (50*10-10%+18%=total amount)

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)