It multiplies all the numbers given to it as arguments and returns the product.
The syntax of the function is the following:
PRODUCT(number1, [number2], …)
number1, [number2], …: The numbers we want to multiply. Only the first argument is required. Each argument can be either a number or a range of numbers. There can be upt to a maximum of 255 arguments.
Empty cells, logical values, and text are ignored
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the PRODUCT function:
In the A6 cell, use the proper function to calculate the product of the cell range Α1:Β4.