Q&A for How to Multiply in Excel

Return to Full Article

Search
Add New Question
  • Question
    How can I multiply two columns together?
    Community Answer
    In another column, create a formula by entering =, then selecting the first value and typing * (which means multiply) before selecting the second value and pressing enter.
  • Question
    How would I multiply 0.5 by a number, such as $37.50?
    Community Answer
    In any cell, you would simply enter = 0.5 * 37.5. As you leave the cell, the answer will be displayed. Alternatively, put 0.5 into cell A1 and 37.5 into cell A2. In cell A3, type = A1*A2. When you press Enter, the answer will be displayed.
  • Question
    When I multiply two numbers, why do they disappear when the product shows up?
    Community Answer
    Excel will only show the product. If you also want to see the numbers you multiplied, you will have to write them again.
  • Question
    How do I multiply a number by a percentage?
    Community Answer
    Use the multiply a number by another number method, and change the percentage to a number. For example, 25% is 0.25 as a number. So to multiply 100 by 25% you would type in 100*0.25
  • Question
    I want to multiply an empty cell with another, what is the formula?
    Community Answer
    An example for the formula of multiplication is "=A1*B1". You can just type the "=" symbol and click on one cell you want to multiply (e.g. A1) and add the "*" symbol and then click on the second cell you want to multiply (e.g. B1) and that's it!
  • Question
    How do I multiply a particular number written in one cell with various numbers mentioned in different cells, and show the result in a separate cell?
    Community Answer
    If you have the other numbers in a row or a column, the easiest formula to apply would be PRODUCT(). Just select the range, and add the particular number you want to multiply them with after a comma. For example, if you have numbers in the range A1:A3 and that specific number in the cell C7, then type this formula in the cell you want the result: =PRODUCT(A1:A3,C7).
Ask a Question

      Return to Full Article