PRODUCT

Multiplies together all the values in a list.

Syntax:

PRODUCT(list)

The PRODUCT function returns the product of all the numeric values in the list, which may be an array, a range of cells, or a comma-separated list of values.

Example:

PRODUCT(B1:B14)

returns the product of the values of cells B1 to B14.