You can use the product function to calculate multiplication.

Step 1: Open the excel document.

Step 2: Enter Formula = Product (C3 B3)

Product features:

The PRODUCT function is used to calculate the product of numbers and then return the product. For example, if cells A 1 and A2 contain numbers, you can use the formula =PRODUCT(A 1, A2) to calculate the product of these two numbers. You can also use multiplication? (*) mathematical operators to perform the same operation, for example, =A 1 * A2.

If you need to multiply many cells, it is useful to use the product function. For example, the formula = product (A 1: A3, C 1: C3) is equivalent to = a1* a2 * a3 * c1* C2 * C3.

Product function grammar:

Products (number 1, [number 2], …)

Parameter description:

Number 1 (required): 1 number representing the required product, which can be a directly entered number, cell reference or array.

Number2, … (optional): the 2nd to 255th digits representing the required product, which can be directly entered numbers, cell references or arrays.

Precautions for using product functions:

(1) If the parameter value is directly entered in the product function, the parameter must be a numeric type, that is, a numeric or logical value in text format.

(2) If cell references or arrays are used as parameters of the product function, the parameters must be numbers, and other types of values will be ignored.

(3) If the parameter is text, the PRODUCT function will return the error value #VALUE! .