Multiplication function (PRODUCT function) in Excel
The multiplication function in Excel is very important for those who often have to process and calculate data in Excel. In Excel you can also use the * operator to multiply data, but with large volumes of data you should use the multiplication function - Product to be able to calculate data faster.
Article instructions syntax and how to use the Product function to multiply data in Excel.
Description
The Product function is a function used to multiply in Excel, which will multiply all the arguments entered and return their product.
You can use the normal * operator, but you should use the Product function to multiply multiple cells in Excel together.
Syntax
= PRODUCT (number1, [number2] .)
Where: number1, number2 are numbers to be multiplied, can be numbers that can be cells in Excel, up to 255 arguments.
Note: If the argument is an array or reference, empty cells and logical values and text in the array will be ignored.
For example: Give the following table and calculate the Total salary for employees.
Use the Product: = PRODUCT function (D5: E5)
To calculate for all the workers you go to the lower right corner in the box you enter the formula (the mouse turns into a + sign) as shown below:
Drag to the last employee and release the mouse button.
So all employees are paid gross salary.
So, instead of using the * operator to process data to multiply, using the Product multiplication function will be effective and help you calculate faster. Just remember the syntax and apply the function appropriately, you will quickly process and calculate data more. Good luck!
You should read it
- How to use the kernel function (PRODUCT function) in Excel
- Basic Excel functions that anyone must know
- How to use the SUM function to calculate totals in Excel
- How to use Hlookup function on Excel
- Save time with these text formatting functions in Microsoft Excel
- DPRODUCT function in Excel
- How to use the IFS function in Excel 2016
- How to use the LEN function in Excel
- How to use COUNTIF function on Excel
- OR function in Excel, how to use the OR function, and examples
- How to use MID functions to get strings in Excel
- How to use the MOD function and QUOTIENT function in Excel
Maybe you are interested
10 Apple Products That Could Be Discontinued Next Week
The DL on AR: Importance, Considerations, and Hot Products
How do you know you can trust a product review?
Solar electric vehicles that can run for 7 months without charging are being put into mass production
What is Arc Browser? Why does it deliver amazing productivity improvements?
Samsung announced 2nm SF2Z chip manufacturing technology, a new solution for high-quality AI products