You are viewing the article How to Multiply in Excel at Lassho.edu.vn you can quickly access the necessary information in the table of contents of the article below.
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
![Image titled Multiply in Excel Step 1](https://www.wikihow.com/images_en/thumb/a/a6/Multiply-in-Excel-Step-1-Version-4.jpg/v4-460px-Multiply-in-Excel-Step-1-Version-4.jpg)
- 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.
![Image titled Multiply in Excel Step 2](https://www.wikihow.com/images_en/thumb/d/df/Multiply-in-Excel-Step-2-Version-4.jpg/v4-460px-Multiply-in-Excel-Step-2-Version-4.jpg)
![Image titled Multiply in Excel Step 3](https://www.wikihow.com/images_en/thumb/f/fd/Multiply-in-Excel-Step-3-Version-4.jpg/v4-460px-Multiply-in-Excel-Step-3-Version-4.jpg)
![Image titled Multiply in Excel Step 4](https://www.wikihow.com/images_en/thumb/a/a4/Multiply-in-Excel-Step-4-Version-4.jpg/v4-460px-Multiply-in-Excel-Step-4-Version-4.jpg)
![Image titled Multiply in Excel Step 5](https://www.wikihow.com/images_en/thumb/8/8e/Multiply-in-Excel-Step-5-Version-4.jpg/v4-460px-Multiply-in-Excel-Step-5-Version-4.jpg)
![Image titled Multiply in Excel Step 6](https://www.wikihow.com/images_en/thumb/6/63/Multiply-in-Excel-Step-6-Version-4.jpg/v4-460px-Multiply-in-Excel-Step-6-Version-4.jpg)
- 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.
![Image titled Multiply in Excel Step 7](https://www.wikihow.com/images_en/thumb/c/ce/Multiply-in-Excel-Step-7-Version-4.jpg/v4-460px-Multiply-in-Excel-Step-7-Version-4.jpg)
Multiply separate cells
![Image titled Multiply in Excel Step 8](https://www.wikihow.com/images_en/thumb/5/54/Multiply-in-Excel-Step-8-Version-4.jpg/v4-460px-Multiply-in-Excel-Step-8-Version-4.jpg)
![Image titled Multiply in Excel Step 9](https://www.wikihow.com/images_en/thumb/2/2e/Multiply-in-Excel-Step-9-Version-3.jpg/v4-460px-Multiply-in-Excel-Step-9-Version-3.jpg)
![Image titled Multiply in Excel Step 10](https://www.wikihow.com/images_en/thumb/e/ec/Multiply-in-Excel-Step-10-Version-3.jpg/v4-460px-Multiply-in-Excel-Step-10-Version-3.jpg)
![Image titled Multiply in Excel Step 11](https://www.wikihow.com/images_en/thumb/5/59/Multiply-in-Excel-Step-11.jpg/v4-460px-Multiply-in-Excel-Step-11.jpg)
- For example, type “A1” in a cell to set the value of cell A1 as the first number in the formula.
![Image titled Multiply in Excel Step 12](https://www.wikihow.com/images_en/thumb/4/4b/Multiply-in-Excel-Step-12.jpg/v4-460px-Multiply-in-Excel-Step-12.jpg)
![Image titled Multiply in Excel Step 13](https://www.wikihow.com/images_en/thumb/4/47/Multiply-in-Excel-Step-13.jpg/v4-460px-Multiply-in-Excel-Step-13.jpg)
- 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.
![Image titled Multiply in Excel Step 14](https://www.wikihow.com/images_en/thumb/f/f1/Multiply-in-Excel-Step-14.jpg/v4-460px-Multiply-in-Excel-Step-14.jpg)
- When you click on the result cell, the formula will automatically appear in Excel’s address bar.
Multiply multiple cells by range
![Image titled Multiply in Excel Step 15](https://www.wikihow.com/images_en/thumb/8/8a/Multiply-in-Excel-Step-15.jpg/v4-460px-Multiply-in-Excel-Step-15.jpg)
![Image titled Multiply in Excel Step 16](https://www.wikihow.com/images_en/thumb/a/a4/Multiply-in-Excel-Step-16.jpg/v4-460px-Multiply-in-Excel-Step-16.jpg)
![Image titled Multiply in Excel Step 17](https://www.wikihow.com/images_en/thumb/9/97/Multiply-in-Excel-Step-17.jpg/v4-460px-Multiply-in-Excel-Step-17.jpg)
![Image titled Multiply in Excel Step 18](https://www.wikihow.com/images_en/thumb/c/c4/Multiply-in-Excel-Step-18.jpg/v4-460px-Multiply-in-Excel-Step-18.jpg)
- For example, you could enter “A1” here.
![Image titled Multiply in Excel Step 19](https://www.wikihow.com/images_en/thumb/5/57/Multiply-in-Excel-Step-19.jpg/v4-460px-Multiply-in-Excel-Step-19.jpg)
![Image titled Multiply in Excel Step 20](https://www.wikihow.com/images_en/thumb/7/71/Multiply-in-Excel-Step-20.jpg/v4-460px-Multiply-in-Excel-Step-20.jpg)
- 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.
![Image titled Multiply in Excel Step 21](https://www.wikihow.com/images_en/thumb/b/bf/Multiply-in-Excel-Step-21.jpg/v4-460px-Multiply-in-Excel-Step-21.jpg)
- 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).
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 Lassho.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: