PRODUCT

Calculates the product of a list of numbers or arrays of numbers.

📘

If a complex array is provided, like children.children, this function will flatten the array to calculate.

Syntax

=PRODUCT(value1, value2, ... valueN)

Arguments

Argument	Type	Description
value	Number or Array	The values used to calculate the product. Allows either numbers or arrays, which can themselves contain numbers or arrays.

Examples

=PRODUCT(1, 2, 3, 4, 5, 6, 7)→5040
Calculates the product of 1, 2, 3, 4, 5, 6, and 7, equivalent to: 1 * 2 * 3 * 4 * 5 * 6 * 7

=PRODUCT(children."Property 1")→2688
Calculates the product of the shape's children's data property value "Property 1" (1, 4, 2, 6, 7, 8)

=PRODUCT(children.children."Property 2")→2880
Calculates the product of the shape's children's children's data property value "Property 2" (12, 15, 16)