Q&A for How to Multiply in Excel

Return to Full Article

Coming soon

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 14 Helpful 17
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 9 Helpful 6
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 2
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

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
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!

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 1
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).

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 7 Helpful 0