You also can click on the selected cells while writing the formula, instead of typing the cell’s name.To extend this formula, drag the cell down to the selected row. The result will be multiplication of the values in cells A1, A4 and B6. If you want to write a formula that multiplies A1, A4, and B6 you should type: The result which is shown in the cell is 336. You can use the asterisk (*) to multiply as many numbers as you like:įor example, if you are willing to write a formula that multiplies 4,7,2, and 6 you should type: Sometimes we enter numbers in the formula and sometimes we prefer to enter a cell.
How to multiply in excel how to#
“=PRODUCT (6 8)” How to multiply cells in Excel?Īs we explained before we can use either “PRODUCT” or (*) as the multiplication symbol. In this formula “PRODUCT” represents multiply function for example: “=6*8” Multiplication formula using PRODUCT function: In this formula, the asterisk (*) represents multiplication for example: Multiplication formula in Excel Multiplication formula using (*) Note that using “=PRODUCT” is not the only way to multiply numbers in Excel. In the following sections, we’ll see how to use the “PRODUCT” function to multiply numbers, cells, columns, and rows. The multiply function in Excel is defined as “PRODUCT.” But it doesn’t mean that you can’t use multiplication in Excel. If you type “=multiplication” in the formula bar in Excel, you’ll see that such a function isn’t available.
To write a multiplication formula in Excel, just like any other function, you start with putting a “=” (equal) symbol in the formula bar. To multiply your data in Excel, some different methods are available. Multiplication in ExcelĪctually, doing multiplication in Excel is really easy, and we’re going to walk you through it. We are going to teach you everything about multiplying in Excel. 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.
0 kommentar(er)
