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], ... )

#1)
Using the PRODUCT function:
#2)
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.
#3)
One more thing:
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.

Summary

The PRODUCT function multiplies all the numbers given as arguments and returns the product.
comments powered by Disqus