If you want to use the multiplication function in Excel and you don’t know how to do it, then you’re in the right place.
We are going to teach you everything about multiplying in Excel.
Multiplication in Excel
Actually, doing multiplication in Excel is really easy, and we’re going to walk you through it.
To multiply your data in Excel, some different methods are available.
To write a multiplication formula in Excel, just like any other function, you start with putting a “=” (equal) symbol in the formula bar.
Multiplication function in Excel
If you type “=multiplication” in the formula bar in Excel, you’ll see that such a function isn’t available. But it doesn’t mean that you can’t use multiplication in Excel.
The multiply function in Excel is defined as “PRODUCT.”
In the following sections, we’ll see how to use the “PRODUCT” function to multiply numbers, cells, columns, and rows.
Note that using “=PRODUCT” is not the only way to multiply numbers in Excel. And we’ll discuss other ways as well.
Multiplication formula in Excel
Multiplication formula using (*)
In this formula, the asterisk (*) represents multiplication; for example:
Multiplication formula using PRODUCT function:
in this formula “PRODUCT” represents multiply function; for example:
How to multiply cells in Excel?
As we explained before we can use either “PRODUCT” or (*) as the multiplication symbol.
Sometimes we enter numbers in the formula and sometimes we prefer to enter a cell.
Let’s see how it’s done.
Multiplication with (*) and numbers
You can use the asterisk (*) to multiply as many numbers as you like:
For example, if you are willing to write a formula that multiplies 4,7,2, and 6; you should type:
The result which is shown in the cell is 336.
Multiplication with (*) and cells
If you want to write a formula that multiplies A1, A4, and B6; you should type:
The result will be multiplication of the values in cells A1, A4 and B6.
To extend this formula, drag the cell down to the selected row.
- You also can click on the selected cells while writing the formula, instead of typing the cell’s name.
- To multiply a cell by a fixed number, just put the fixed number (for example 6) inside the equation:
Multiplication with PRODUCT function and numbers
PRODUCT function is actually a shortcut to writing multiplication formulas in Excel.
Let’s consider the previous example again:
If you want to write a formula that multiplies 4,7,2, and 6; You can use PRODUCT function:
Multiplication with PRODUCT function and cells
To write a formula that multiplies A1, A4, and B6; you should type:
- To multiply a range of data (for example A1, A2, A3, ans A4), you can easily type:
- You can put any combination of, formulas, ranges, cells, and numbers in this formula; for example:
“=PRODUCT (4; A1:A16; D2:D9)”
check out our other blogs, explaining the other three basic arithmetic operations in Excel: