Excel has been around for about 50 years. It is an essential component of Microsoft Office products, alongside Microsoft Word. Nonetheless, some folks are just starting started with this spreadsheet application.
If you’re still confused about how to multiply in Excel, this detailed tutorial is for you.
Multiplication Methods in Excel
There are several methods to multiply in Microsoft Excel. However, the two most prevalent techniques are as follows:
- Using the Asterisk Symbol for Multiplication
- Using the Product Function to Multiply
How to Multiply Using the Asterisk Symbol in Excel
When working with Excel, keep in mind that the multiplication sign is substituted with an asterisk (*). As a result, if you wish to represent 5 x 3, you should use 5*3. And, yeah, there are no spaces.
Another Excel guideline is that when creating a formula in a cell, you should always begin with the equals symbol (=). This operation informs Excel that you are entering a formula.
Thus, entering =5*3 and pressing Enter should provide the result (15).
How to Multiply Two Cells in Excel
You may also multiple two cells in Excel if both cells include numerical data. Assume, for example, that cell A3 contains 5 and cell B3 contains 3. Here’s how to quickly multiply them, with the result shown in cell C3:
- In cell C3, enter the equals symbol (=).
- Then, in cell A3, click to add it to your formula.
- After that, enter an asterisk (*) and click on cell B3.
- Finally, press Enter to get the answer.
You may also enter in the mobile number instead. You may enter as many multipliers as you wish, as long as you separate them with an asterisk.
How to Multiply Two Columns in Excel
You may multiply two groups of numbers that are lined up in a column by batch. Assume you have an hourly rate in column A and labor hours in column B.
To get the product in column C, here’s what you should do:
- In column C, type the equals symbol (=) into the cell that corresponds to the first row of values. That would be in C3 in our scenario.
- Then, in the cell containing the multiplicand, enter an asterisk (*). A multiplicand is a number that is multiplied by another.
- Then, to create the solution, click on the cell with the multiplier and press Enter. A multiplier is a number that is multiplied by the multiplicand.
- Cell C3 is the previously answered cell. Hover your mouse cursor on the cell border’s bottom right corner. Then, using the mouse cursor, drag down until you reach the final row where you wish the answers to appear.
This is how it should look like in the spreadsheet:
It’s also worth noting that this works if you wish to work on rows with the multiplier and multiplicand columns. However, you must drag the formula to the side instead.
How to Multiply Using the Product Function in Excel
Now, let’s move on to something more advanced.
Microsoft Excel provides a plethora of functionalities. For our needs, we’ll use the PRODUCT function, which multiplies all the integers you provide as parameters.
To use this function, enter the equals symbol (=) followed by the word PRODUCT into a cell. Excel will automatically produce an open parenthesis. Following that, you must perform the following:
- Before adding a comma, provide the multiplicand cell address, say A3 (,).
- Next, type in the multiplier cell reference, say B3, and then type in closed parentheses.
- Hit Enter, and it should generate the answer.
It’s worth noting that you can multiply cells by just clicking on them rather than entering them.
Drag downwards or sidewards from the bottom-right corner of the cell, depending on where you want the products to be, to fill in the remainder of the column or row with the same formula.
How to Multiply Using Multiple Rows or Columns
There are additional situations when you will not simply multiply two numbers in distinct rows or columns.
Assume you have values in columns A, B, C, D, and E, and you want your responses in column F. Here’s what you can do with what we’ve learnt so far when dealing with several numbers:
Using the Asterisk Method
Before pressing Enter, enter the following formula in cell F3: =A3*B3*C3*D3*E3.
Here’s how it should look like in the spreadsheet:
Using the Product Function Method
Before pressing Enter in field F3, enter the following: =PRODUCT (A3,B3,C3,D3,E3).
Here’s how it looks like in the Excel sheet:
Both techniques are acceptable, however you may use a shorter string of formulae if you like.
Using the Range-of-Cells Method
We’ll still use the PRODUCT function here, but instead of a comma, we’ll use a colon (:). The use of a colon instructs Excel to process the range indicated by the first and final cell addresses.
As a result, if we enter =PRODUCT(A3:E3), Excel will multiply all of the numbers in cells A3 through E3.
This approach may also be used to generate replies in a row based on the values in the column.
You may also use a combination of the instructions. If you put =PRODUCT (A3:E3,5), Excel will multiply all the integers from A3 to E3 before multiplying them by 5.
Depending on the mathematical issue, there are several possibilities to attempt. You may also experiment with more advanced Excel formulae in the future.
Ready to Be a Microsoft Excel Expert?
This article is only a primer on how to multiply in Microsoft Excel. There are many functions and features that we left untouched since it might intimidate new users of the worksheet. But, you can always refer to this easy guide if you ever feel stuck when working on your spreadsheet.
You are looking for information, articles, knowledge about the topic Excel Multiplication on internet, you do not find the information you need! Here are the best content compiled and compiled by the appsladder.com team, along with other related topics such as: How To.
Related videos about Excel Multiplication