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)
Updated 8 months ago