You are viewing the article How to Multiply in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 2,201 times.
This wikiHow teaches you how to multiply numbers in Excel. You can multiply two or more numbers in an Excel cell, or you can multiply two or more Excel cells together.
Steps
Multiply in a cell
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a6/Multiply-in-Excel-Step-1-Version-4.jpg/v4-728px-Multiply-in-Excel- Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a6/Multiply-in-Excel-Step-1-Version-4.jpg/ v4-728px-Multiply-in-Excel-Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Open Excel. The app is green with a white “X”.
- You need to click Blank workbook on PC, or select New and then click Blank Workbook for Mac to continue.
- Double-click an existing workbook to open the document in Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/df/Multiply-in-Excel-Step-2-Version-4.jpg/v4-728px-Multiply-in-Excel- Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/df/Multiply-in-Excel-Step-2-Version-4.jpg/ v4-728px-Multiply-in-Excel-Step-2-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click a cell to select and enter numbers in it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fd/Multiply-in-Excel-Step-3-Version-4.jpg/v4-728px-Multiply-in-Excel- Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fd/Multiply-in-Excel-Step-3-Version-4.jpg/ v4-728px-Multiply-in-Excel-Step-3-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Type the = sign in the box. All Excel formulas start with an equals sign.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a4/Multiply-in-Excel-Step-4-Version-4.jpg/v4-728px-Multiply-in-Excel- Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a4/Multiply-in-Excel-Step-4-Version-4.jpg/ v4-728px-Multiply-in-Excel-Step-4-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter the first number immediately after the “=”, without spaces.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8e/Multiply-in-Excel-Step-5-Version-4.jpg/v4-728px-Multiply-in-Excel- Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8e/Multiply-in-Excel-Step-5-Version-4.jpg/ v4-728px-Multiply-in-Excel-Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Type * after the first number. The asterisk in the middle indicates that you want to multiply the front and back numbers together.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/63/Multiply-in-Excel-Step-6-Version-4.jpg/v4-728px-Multiply-in-Excel- Step-6-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/63/Multiply-in-Excel-Step-6-Version-4.jpg/ v4-728px-Multiply-in-Excel-Step-6-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter the second number. For example, if you entered the number 6, and wanted to multiply it by 6, the formula would look like this =6*6 .
- You can repeat this process with as many numbers as you want, as long as there is a “*” between each number you want to multiply.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/ce/Multiply-in-Excel-Step-7-Version-4.jpg/v4-728px-Multiply-in-Excel- Step-7-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/ce/Multiply-in-Excel-Step-7-Version-4.jpg/ v4-728px-Multiply-in-Excel-Step-7-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Press ↵ Enter . The formula will run and the result will appear in the selected cell, however, when you click on the cell, the formula will still show up in the address bar of Excel.
Multiply separate cells
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/54/Multiply-in-Excel-Step-8-Version-4.jpg/v4-728px-Multiply-in-Excel- Step-8-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/54/Multiply-in-Excel-Step-8-Version-4.jpg/ v4-728px-Multiply-in-Excel-Step-8-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Open the Excel spreadsheet. Double-click an existing workbook to open the document in Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2e/Multiply-in-Excel-Step-9-Version-3.jpg/v4-728px-Multiply-in-Excel- Step-9-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2e/Multiply-in-Excel-Step-9-Version-3.jpg/ v4-728px-Multiply-in-Excel-Step-9-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click a cell to select and enter numbers in it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ec/Multiply-in-Excel-Step-10-Version-3.jpg/v4-728px-Multiply-in-Excel- Step-10-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ec/Multiply-in-Excel-Step-10-Version-3.jpg/ v4-728px-Multiply-in-Excel-Step-10-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Type the = sign in the box. All Excel formulas start with an equals sign.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/59/Multiply-in-Excel-Step-11.jpg/v4-728px-Multiply-in-Excel-Step-11. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/59/Multiply-in-Excel-Step-11.jpg/v4-728px-Multiply-in-Excel-Step- 11.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Enter the name of another cell right after the “=”, remember that there is no way out.
- For example, type “A1” in a cell to set the value of cell A1 as the first number in the formula.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4b/Multiply-in-Excel-Step-12.jpg/v4-728px-Multiply-in-Excel-Step-12. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4b/Multiply-in-Excel-Step-12.jpg/v4-728px-Multiply-in-Excel-Step- 12.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Type an * after the name of the first cell. The asterisk in the middle indicates that you want to multiply the front and back numbers together.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/47/Multiply-in-Excel-Step-13.jpg/v4-728px-Multiply-in-Excel-Step-13. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/47/Multiply-in-Excel-Step-13.jpg/v4-728px-Multiply-in-Excel-Step- 13.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Type in another cell name. The value of the second cell will be the second variable in the formula.
- For example, if you enter “D5” in a cell, your formula will become:
=A1*D5. - We can add more than two cells to the formula, however, you need to put an “*” in between the subsequent cells.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f1/Multiply-in-Excel-Step-14.jpg/v4-728px-Multiply-in-Excel-Step-14. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f1/Multiply-in-Excel-Step-14.jpg/v4-728px-Multiply-in-Excel-Step- 14.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Press ↵ Enter . The formula will run and the result will appear in the selected cell.
- When you click on the result cell, the formula will automatically appear in Excel’s address bar.
Multiply multiple cells by range
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8a/Multiply-in-Excel-Step-15.jpg/v4-728px-Multiply-in-Excel-Step-15. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8a/Multiply-in-Excel-Step-15.jpg/v4-728px-Multiply-in-Excel-Step- 15.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Open the Excel spreadsheet. Double-click an existing workbook to open the document in Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a4/Multiply-in-Excel-Step-16.jpg/v4-728px-Multiply-in-Excel-Step-16. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a4/Multiply-in-Excel-Step-16.jpg/v4-728px-Multiply-in-Excel-Step- 16.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Click a cell to select and enter the data.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/97/Multiply-in-Excel-Step-17.jpg/v4-728px-Multiply-in-Excel-Step-17. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/97/Multiply-in-Excel-Step-17.jpg/v4-728px-Multiply-in-Excel-Step- 17.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Type =PRODUCT( into the cell of your choice. This command indicates that you want to multiply multiple items together.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c4/Multiply-in-Excel-Step-18.jpg/v4-728px-Multiply-in-Excel-Step-18. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c4/Multiply-in-Excel-Step-18.jpg/v4-728px-Multiply-in-Excel-Step- 18.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Type in the first cell name. This is the first cell in the data series.
- For example, you could enter “A1” here.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/57/Multiply-in-Excel-Step-19.jpg/v4-728px-Multiply-in-Excel-Step-19. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/57/Multiply-in-Excel-Step-19.jpg/v4-728px-Multiply-in-Excel-Step- 19.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Type : . The colon (“:”) tells Excel that you want to multiply all the data from the first cell up to the next cell where you’ll enter the name.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/71/Multiply-in-Excel-Step-20.jpg/v4-728px-Multiply-in-Excel-Step-20. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/71/Multiply-in-Excel-Step-20.jpg/v4-728px-Multiply-in-Excel-Step- 20.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Type in another cell name. The second cell must be in the same column or row of the first cell in the formula if you want to multiply all the data from the previous cell to the next cell.
- In this example, if you enter “A5”, the formula will be set to multiply the data of cells A1, A2, A3, A4, and A5 together.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/bf/Multiply-in-Excel-Step-21.jpg/v4-728px-Multiply-in-Excel-Step-21. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/bf/Multiply-in-Excel-Step-21.jpg/v4-728px-Multiply-in-Excel-Step- 21.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Type ampersand ) , then press ↵ Enter . The last parenthesis will close the formula, after you press enter to execute the command, the range of numbers will be bulk multiplied and display the result immediately in the selected cell.
- If you change the data of a cell in the multiplier range, the value in the resulting cell will also change.
Advice
- When you apply the PRODUCT formula to the product of a range of numbers, you can select more than just a row or column. For example, your sequence of numbers could be =PRODUCT(A1:D8). This formula will multiply all values in the rectangle specified by the range (A1-A8, B1-B8, C1-C8, D1-D8).
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 2,201 times.
This wikiHow teaches you how to multiply numbers in Excel. You can multiply two or more numbers in an Excel cell, or you can multiply two or more Excel cells together.
Thank you for reading this post How to Multiply in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: