PRODUCT

The PRODUCT function multiplies multiple values together and returns the resulting value. It performs multiplication across all provided numbers or node references and is commonly used in calculations involving totals, scaling factors, or combined values.

Syntax

PRODUCT(value1, value2, ... valueN)

Arguments

• value1, value2, ... valueN: Numbers or node references to multiply.

Return value

Returns the product of the specified values.

Example

PRODUCT(Unit Price, Units)

In this example, the Total Sales measure is created using the PRODUCT function, which returns the product of the values in Unit Price and Units.

Excel equivalent

PRODUCT