How to Multiply in Excel
Multiply in one cell
How to Multiply in Excel Picture 1
Open Excel. The app is green with a white "X".
You'll need to click Blank workbook on PC, or select New and then click Blank Workbook on Mac to continue.
Double-click an existing spreadsheet to open the document in Excel.
How to Multiply in Excel Picture 2
Click a cell to select it and enter data into it.
How to Multiply in Excel Picture 3
Type a check mark = in the box. Every Excel formula begins with an equal sign.
How to Multiply in Excel Picture 4
Enter the first number immediately after the "=" sign, without spaces.
How to Multiply in Excel Picture 5
Type the sign *after the first number. The asterisk in the middle shows that you want to multiply the front and back numbers together.
How to Multiply in Excel Picture 6
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 like, as long as there is a "*" between each number you want to multiply.
How to Multiply in Excel Picture 7
Press ↵ Enter. The formula runs and the results appear in the selected cell, however, when you click the cell the formula still displays in Excel's address bar.
Multiply multiple separate cells
How to Multiply in Excel Picture 8
Open the Excel spreadsheet. Double-click an existing spreadsheet to open the document in Excel.
How to Multiply in Excel Picture 9
Click a cell to select it and enter data into it.
How to Multiply in Excel Picture 10
Type a check mark =in the box. Every Excel formula begins with an equal sign.
How to Multiply in Excel Picture 11
Enter the name of another cell right after the "=" sign, remember not to leave spaces.
For example, type "A1" in the cell to set the value of cell A1 as the first number in the formula.
How to Multiply in Excel Picture 12
Type a mark * after the name of the first cell. The asterisk in the middle shows that you want to multiply the front and back numbers together.
How to Multiply in Excel Picture 13
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 a "*" between the next cells.
How to Multiply in Excel Picture 14
Press ↵ Enter. The formula will run and the results appear in the selected cell.
When you click on the result cell, the formula will appear in Excel's address bar.
Multiply multiple cells by range
How to Multiply in Excel Picture 15
Open the Excel spreadsheet. Double-click an existing spreadsheet to open the document in Excel.
How to Multiply in Excel Picture 16
Click a cell to select and enter data.
How to Multiply in Excel Picture 17
Type =PRODUCT(in the box of your choice. This command shows that you want to multiply multiple items together.
How to Multiply in Excel Picture 18
Type in the first cell name. This is the first cell in the data series.
For example, you could enter "A1" here.
How to Multiply in Excel Picture 19
Type : . The colon (":") tells Excel that you want to multiply all the data from the first cell to the next cell where you'll enter the name.
How to Multiply in Excel Picture 20
Type in another cell name. The second cell must be in the same column or row as 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 numbers in cells A1, A2, A3, A4 and A5 together.
How to Multiply in Excel Picture 21
Type ), then press ↵ Enter. The last parenthesis will close the formula. After you press enter to execute the command, the data range will be multiplied and the results will be displayed immediately in the selected cell.
If you change the data of a cell in the multiplier series, the value in the resulting cell will also change.
You should read it
- How to Multiply in Excel
- How to multiply numbers in Google Sheets
- How to use the kernel function (PRODUCT function) in Excel
- Multiplication function (PRODUCT function) in Excel
- Get started with Excel for beginners
- Tips for adding in Excel you need to know
- How to fix the SUM function doesn't add up in Excel
- Guidance on how to align Excel correctly
- 11 tips to solve Math simple but extremely interesting
- How to keep Excel and Excel columns fixed?
- What is ### error in Excel? how to fix ### error in Excel
- How to display 0 in front of a number in Excel