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 →

Comments page 2. Total comments: 72

  1. I want to one formula people age.
    If current time and date in one box fix.
    One column is date of birth. One column vale is either death or alive. If people die results show zero.

  2. A B C D E
    1 SAKO Portier Cleaning %
    2 Adam 21.8
    3 Thomas 15.2
    4 Jack 11.0
    5 John 11.0
    6 Smith 12.2
    7 Jef 8.4
    8 David 20.6
    9 Total 3400 5500 7300 100

    Hi
    Could you please provide me with an excel formula to fill out the above Excel matrix by distributing the items in total row among the persons by using the percentage stated in the column. Many thanks for your kind cooperation

  3. 19.46 * 8000 is giving me 155,652.91 but the real answer is 155,680. Why is excel giving me this number?

    1. Hello!
      I assume that 19.46 is the result of calculating the formula, and not entering this value manually. If you increase the number of decimal places in the number format, you will see that this is not 19.46 but 19.45661375
      You can use the ROUND function in the formula so that the number on the screen does not differ from the real number.

  4. I need to multiply one cell by another, repeatedly where only one changes. So, I want C3 * D2, C4*D2, C5*D2, but when I put in the first formula and drag down the column, it gives me C3*D2, C4*D3, C5*D4 -- it changes the second number. I have tried putting a $ before the D value =PRODUCT(C3*$D2) but it does not help. I want the D2 to remain constant and each C to multiply by the D2 number.

  5. My problem is simple, in A column is a, b, c, d, e, f, g repeate randomly up to millions, corresponding value 3, 5, 4, 6, 2, 7, 1, 8 randomly, multiply with colum B, Each cell value is different, more than two lac.... please solve my problem with exact formula wth helper.....

  6. My question ( 0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84)*7.06 +(0.83+0.83+0.82+0.82+0.81+0.81+0.80+0.80+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)7.57 /(0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84+0.83+0.83+0.82+0.82+0.81+0.81+0.80+0.80+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75) My ans. 59.53 but actual ans. 7.3765
    My Formula = =SUM(F11:N11)*7.06+SUM(O11:AD11)*7.57/SUM(F11:AD11) Please suggest right ans.

    1. Hello!
      Your formula:
      =(0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84)*7.06+(0.83+0.83+0.82+0.82+0.81+0.81+0.8+0.8+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)*7.57/(0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84+0.83+0.83+0.82+0.82+0.81+0.81+0.8+0.8+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)

      =SUM(F11:N11)*7.06+SUM(O11:AD11)*7.57/SUM(F11:AD11)
      Answer: 59.549

      Formula:

      =((0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84)*7.06+(0.83+0.83+0.82+0.82+0.81+0.81+0.8+0.8+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)*7.57)/(0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84+0.83+0.83+0.82+0.82+0.81+0.81+0.8+0.8+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)

      =(SUM(F11:N11)*7.06+SUM(O11:AD11)*7.57)/SUM(F11:AD11)
      Answer: 7.376

      You can choose yourself.

  7. hey, I am trying to find a formula that will multiply the value up to x by y, and over x by Z, example if the up to 10000 multiply by one, and everything above 10000 multiply by 2, what would be the best way to do that?

  8. Hi, I need to multiply one cell by another and add those totals all the way across my spread sheet. Similar to this =(B8*$B$4)+(C8*$C$4)+(D8*$D$4)+(E8*$E$4)+(H8*H$4) but much longer. Is there a formula or function where I can do this without typing each out?

    1. Hi Kelly,
      Here is the formula that should do the trick for you:

      =(B8*$B4) + (C8*$C4) + (D8*$D4) + (E8*$E4) + (H8*$H4)

  9. 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())

  10. 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!

  11. 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)

  12. 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.

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)