In Microsoft Excel, you can multiply numbers by using the Multiplication and Division (MD) function. The MD function takes two input parameters: the number of digits to be multiplied and the number of digits to be divided. The MD function will return a new number that is equal to the sum of the two input numbers. To use the MD function, you must first create a worksheet and then add a column called “Multiply” to it. In this column, you will need to provide two input numbers: the number of digits to be multiplied and the number of digits to be divided. Next, you must use the MD function to create a result sheet by adding another column called “Divide”. In this column, you will need to provide three input numbers: the number of digits to be multiplied, the number of digits to be divided, and the result sheet’s width in inches. You can also use other formulas in this column such as “Add”, “Subtract”, or “Multiply/Divide”. When you are finished creating your result sheet, make sure that your worksheet is saved by clicking on its name in the left-hand pane of your spreadsheet window.
You can perform basic mathematical operations in Excel, including multiplication. You can multiply numbers in a single cell, from several different cells, or even an entire column. There’s no MULTIPLY function in Excel, so we’ll use a simple formula.
RELATED: Functions vs. Formulas in Microsoft Excel: What’s the Difference?
Multiply Numbers in a Single Cell
You can use a simple formula to multiply numbers in a single cell. Open Excel and then select the cell you’d like to input the equation. Once selected, enter this formula:
Replace a and b with the numbers you’d like to use. So if you want to multiply 5 by 7, you’d enter:
Next, press Enter and the result of the formula will appear.
Multiply Numbers From Multiple Cells
You can enter a formula in a blank cell to multiply data from other cells. For example, let’s say you have 5 in cell A2 and 7 in cell A3, and you want the product of these two figures. In a blank cell, enter this formula:
This formula pulls the data from each entered cell for calculation. Press “Enter” and the result will appear.
Multiply a Column of Numbers (by a Constant Number)
You can multiply a column of numbers by a number in a different cell. For example, let’s say cells A1-A6 each contain a number (your multiplicands), and you want to get the product of those by using the number in cell C1 (your multiplier).
First, select cell B2, which is where the output of the first formula will be. In B2, enter this formula:
Press “Enter” and the product will appear.
The $ key tells Excel that the number in cell C1 is absolute. So if you were to click and drag the formula in B1 down, the A1 part of the formula will change to A2, A3, and so on, while C1 will remain the same.
That’s all there is to it.
This is just one of the basic calculations you can do in Excel. You can also divide, add, subtract, and much more.
RELATED: How to Calculate the Median in Microsoft Excel
