PRODUCT:
Multiplies its arguments
The PRODUCT function multiplies all the numbers given as arguments and returns the product.
PRODUCT takes
1 required argument and
254 optional arguments:
Syntax: PRODUCT(number1,
[number2], ...
)
Using the PRODUCT function:
The arguments for the PRODUCT function are:
Argument

Required?

Description

number1 
Required 
The first number or range that you want to multiply. 
number2, ... 
Optional 
Additional numbers or ranges that you want to multiply, up to a maximum of 255 total arguments. 
• If an argument is an array or reference, only numbers in the array or reference are multiplied. Empty cells, logical
values, and text in the array or reference are ignored. 
The PRODUCT function multiplies all the numbers given as arguments and returns the product.