PRODUCT

Description

Multiplies a list of numbers and returns the result.

Syntax

PRODUCT ( number_list )

Parameter	Description
number_list	A list of up to 30 comma-separated numbers or source fields: The list can contain numbers (including 0), logical values, or text representations of numbers. Source fields can contain only a single value. Error values or text that cannot be translated into numbers return errors. If there are no numbers in the list, 0 is returned.

Examples

This function returns 24:

PRODUCT(1, 2, 3, 4)

For the following example, assuming that S7 contains 34, S8 contains 227, and S9 contains 74, this function returns 571,132:

PRODUCT(S7,S8,S9)

Note: While 0 (zero) is a valid parameter, keep in mind that it will cause PRODUCT to return 0.