PRODUCT(<List>)

 

Description

This function multiplies all the numeric elements of the argument list, ignoring empty and non-numeric values, and returns the product.

 

Parameters

 

<List>

Any combination of numbers, cells, or ranges.

 

Examples

 

PRODUCT(6, 5, 8, 2) = 480

 

PRODUCT(A1:A3) = 25.1327

Where A1:A3 = 2, PI(), 4.