Double-click the cell E2, copy the formula =PRODUCT(C2,D2) to E2, press Enter, return to 2405 select E2, move the mouse to the cell fill handle in the lower right corner of E2, after the mouse becomes the bold black plus(+), double-click the left button to return the remaining turnover the operation process steps, as shown in Figure 1:Ģ. (I) Examples of multiplication of the numbers in two columnsġ. II, The examples of Excel Product function(Multiply function in Excel) If the array or cell range to be referenced contains spaces or text, they are also ignored when evaluated. If the logical values(True and False) are directly used as arguments to the Product function, True is converted to 1, and False is converted to 0 if the logical values are in an array or cell to be referenced, they are ignored.Ĭ.
Product function can only have a maximum of 255 Number.ī.
The difference is: one is modified in the original data and the other is generating new data.ġ. They are implemented by the functions provided by Excel, and can also be implemented by Excel multiply formula or division formula. You usually encounter all the numbers that are multiplied or divided by a number in the multiplication and division calculation process.
HOW TO MULTIPLY IN EXCEL HOW TO
In addition, how to divide in excel? There are two ways to calculate the division, one is to use the Product function, and the other is to use the slash(/), the difference is the same as the calculation multiplication. The Product function not only takes a single value as a argument, but also takes an array and a reference to cells as arguments, for example, to calculate the product of all values in A1 to A6, it does not need to be written one by one, just write A1:A6 and it can be written only one by one with an asterisk. The calculation of multiplication can be either a Product function or an asterisk * in Excel, but they differ.
0 kommentar(er)
