excel function multiplication how to use two methods to teach you to use
Excel tables support simple calculations and statistics. There are two ways to achieve this effect, respectively, the PRODUCT function method and multiplication function method. Here let me take WPS version 11.11.10 as an example to show you how to operate.
Method 1: PRODUCT function method
Step 1: Select any cell, in the upper edit box, enter [= PRODUCT (cell one, cell two, cell three, ……)] function. In this example, we enter [= PRODUCT (A1, B1)] function, and then click Enter.
Step 2: The visible product of the two cells has been displayed in the blank cell.
Method 2: multiply the number of function method
Step 1: Select any cell, in the upper edit box, enter [= cell one * cell two * cell three * ……] function. In this example, we enter [= A1 * B1] function, and then click Enter.
Step 2: The visible product of the two cells has been displayed in the blank cell.
Tip: Method one of the use of the PRODUCT function can only support the calculation of up to 30 data values of the product, but method two does not limit the number of data.