2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016

calculate product

When you learn to make tables that are no longer limited to summing, differencing, quotienting and averaging, you can start to focus on how to multiply two or more cells. Cross product is something that you often use in mathematics. We can calculate the number of small points by heart, but the number is large, or plenty of number needs to be calculated, which is a little bit difficult at this point, so I think it is useful to choose to automatically compute the product in Excel, which can not only quick and accurate but also convenient.

So I’m going to share with you a little bit about how to do this in Excel. Whether you used to use Excel or not, I’m sure you’ll be able to take the product yourself after reading this tutorial.

2 methods to perform PRODUCT calculation on the data in Excel 2016

Method 1: Type the formula to perform PRODUCT calculation

Step 1: Open the target Excel, type the formula “=C2*D2*E2” in the F2 cell and press Enter.

type the formula

Or enter the formula “=PRODUCT(C2:D2:E2)” in the F2 cell and press Enter to display the product.

press enter

Step 2: As you can see, the product of C2:E2 displays in the F2 cell. Then move the cursor to the lower right corner of the F2 cell, press the left button of the mouse and drag it down when it is a solid black cross “+“.

drag it down

Step 3: When you let go of the mouse, you will find that all the calculations of the automatic cross-product are done, as shown in the figure below.

product are done

Method 2: Insert function to perform PRODUCT calculation

Step 1: Select the F2 cell, switch to the Formulas and click the Insert Function in the library group.

click Insert Function

Step 2: The “Insert Function” dialog box pops up, select Math&Trig function in the category, then select PRODUCT function in the text box below, and click OK.

select PRODUCT function

Step 3: The “Function Arguments” window will pop up, type C2:E2 in Number1, and click OK.

type C2:E2

Alternatively, you can also choose to click the button with a red arrow.

click red arrow

This Function Arguments window will appear, select the region of C2:E2, and then C2:E2 will be displayed in the box. Click the red arrow button again.

select the region of C2:E2

Next, you’ll see C2:E2 in the Number1 box, and click OK.

click OK

Step 4: At this time, the product of C2:E2 appears in F2 cell, and then move the cursor to the lower right corner of the F2 cell and drag down a solid black cross until all the automated cross-product calculations are displayed.

product calculations are displayed

You May Also Like

About the Author: Darren

Leave a Reply

Your email address will not be published. Required fields are marked *