HomeApplicationOffice informationMultiplication function (PRODUCT function) in Excel

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.

Multiplication function (PRODUCT function) in Excel Picture 1

Use the Product: = PRODUCT function (D5: E5)

Multiplication function (PRODUCT function) in Excel Picture 2

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:

Multiplication function (PRODUCT function) in Excel Picture 3

Drag to the last employee and release the mouse button.

Multiplication function (PRODUCT function) in Excel Picture 4

So all employees are paid gross salary.

Multiplication function (PRODUCT function) in Excel Picture 5

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!

4 ★ | 1 Vote

You should read it

May be interested

  • Round function (rounding) in ExcelPhoto of Round function (rounding) in Excel
    round function (rounding) in excel - the following article shows you the syntax of the round function and specific examples to help you understand and visualize more.
  • How to print in ExcelPhoto of How to print in Excel
    article on how to set the parameters before printing and how to print in excel 2010.
  • The SUM function (sums) in ExcelPhoto of The SUM function (sums) in Excel
    sum in excel is essential in calculating and processing your data, so the sum and sumif functions are used a lot by you. but for those of you who are new to excel spreadsheets, you probably don't fully understand these two functions.
  • Numbering in ExcelPhoto of Numbering in Excel
    numbering the data in an excel spreadsheet is very necessary, instead of having to enter the numbers from the beginning to the end, you can do some quick operations to automatically number the order. self for excel spreadsheet.
  • How to add rows and columns in ExcelPhoto of How to add rows and columns in Excel
    how to add rows and columns in excel. the article shows you 3 ways to add rows (rows) or add columns in excel.
  • Create Hyperlink in WordPhoto of Create Hyperlink in Word
    in the process of working with word, surely not less or less you will also need to insert website links, e-mail or links to files in your computer to make the text full and complete.

Office information