How to use the kernel function (PRODUCT function) in Excel

In Excel, to be able to sum the values ​​in the data table the user will use the SUM function. And if you want to calculate arguments, or calculate factorials, use the PRODUCT function.

On Excel there is also a way to calculate that multiplication is to use the * operator to multiply the data. However, the * operator is only suitable for small and simple data cases. When dealing with multiple tables of complex data, large data volumes, the use of PRODUCT function will help calculate data faster. The following article will detail how to use the PRODUCT properties feature in Excel and examples for each case.

Multiplication function syntax (PRODUCT function)

The PRODUCT function syntax on Excel is = PRODUCT (number1, [number2] .) .

Of which number1, number2 are numbers to be multiplied, here you can use numbers or can be cells in Excel, up to 255 arguments. If the multiplication function object is arrays or references, with empty cells, logical values, the text will not be counted.

Examples of PRODUCT functions

Example 1 : Calculating the product of numbers

We will compute the product of the numbers 5, 3, 2 and the formula to calculate = PRODUCT (5, 3, 2) = 30.

If the multiplication expression has a zero, PRODUCT also produces the correct result.

Example 2 : Calculate the product of each column in the table

To calculate the product of a column in the data table with the data table as shown below, enter the formula = PRODUCT (B2: B6) . The result returned is very accurate.

Example 3 : Calculate the salary of the employee with a salary of 1 workday and workday.

Method 1 : Here the user can use the * operator to calculate the employee's actual salary. This way is very simple.

The user enters the formula E2 = C2 * D2 . Soon you will receive a real salary of 1 employee. Scroll down to automatically enter results.

Method 2 : We will use the PRODUCT function to calculate the amount of money each employee receives.

Enter the formula in the result box in the Salary column = = PRODUCT (C2, D2) and press Enter to perform the calculation function.

The payroll results when using PRODUCT are similar to those used with the * operator. You pull down the remaining boxes to enter the salary for the remaining employees.

The multiplication on Excel will have two different ways, but in the case of having to work with multiple arrays, more data will use the PRODUCT function faster. We just need to enter the name of the PRODUCT function and select the area to be calculated.

I wish you all success!