Microsoft Excel is arguably one of the most useful softwares in the world. If numbers are your thing, then Excel becomes almost indispensable for your needs. It is not just that Excel makes it easier to crunch numbers but you can do a lot more. One of the things it does well is multiplying your numbers. By multiplication, we are not referring to typical multiplication that you do on a calculator.
On Microsoft Excel, you can do multiplication across cells, rows and columns. It is no surprise that multiplication is one of the most widely performed arithmetic operations on the spreadsheet tool. If the action is performed so often then it is clear that you can perform these actions in multiple ways. Here is how you can perform simple as well as complex multiplication on Microsoft Excel.
Microsoft Excel: how to multiply two numbers or cells
This is one of the simplest arithmetic operations you will perform on Microsoft Excel. The easiest way to perform this operation is to simply two numbers in a single cell. All you need to know for this is a simple formula. In order to multiply two numbers, say 5 and 6, all you need to do is type “=5*6” into a cell and press Enter on the keyboard. You will see the cell display the answer “30” in that cell.
You can also multiply two different cells like we did above for two numbers. Here is how:
- Go to a blank cell and type “=”
- Click on the cell that contains the first number you want to multiply.
- Type “*” next to it.
- Now, click on the cell containing the second number to be multiplied.
- Press Enter.
Microsoft Excel: how to use PRODUCT formula to multiply cells and numbers
With the PRODUCT formula, Microsoft Excel allows its users to multiply up to 255 values at once. This formula forms the basis of numerous calculations done on Excel by accountants and other professionals. With this formula, you can multiply individual cells and numbers by separating them with commas. A series of cells can be multiplied with the help of a colon.
Here is an example: Using the formula “=PRODUCT(A1,A2:A5,D3,D4)” will result in Excel multiplying A1 x A2 x A3 x A4 x A5 X D3 x D5). By using A2:A5, we define Excel to multiply starting from cell A2 up to A5, i.e. A2 x A3 x A4 x A5. We could have used A1:A5 to get the same result. Since we are only doing multiplication, you don’t need to worry about the BODMAS rule or order in which multiplication takes place.
Microsoft Excel: how to multiply a column of values by a constant
There might arise an occasion where you will have a series of numbers compiled in a column and would want to multiply each one of them by the same number. Imagine, you have the weight of multiple products entered and now want to check how much they would weigh if you put a number of them together. While it would be a daunting task manually, Microsoft Excel makes it easy. Here is how.
- First ensure you have the column of numbers set up to multiply.
- Put the constant that you want to multiply in another cell.
- Now, go to a new cell and type “=” and click the first cell you want to multiply.
- Type the name of the cell containing the constant number and add a “$” sign before the letter and number.
- The use of dollar sign turns that cell into an absolute reference number. It won’t change if you copy and paste it in the spreadsheet.
- Press Enter.
- You can now copy and paste this to additional cells to perform the multiplication on other numbers as well.
- You can do this by dragging the cell by its lower right corner to copy it.