Investment Studio > Expressions > Functions > Math & Trig > PRODUCT

float product(float data [, ...])

Returns the product of all arguments which are (or can be converted to) real numbers.

The input data may include arrays, in which case each array element will be treated as a separate argument.

Example

=product(5, 6, {{7, "8"}, {TRUE, "This is not a number!"}})

equals1680: "8" is converted to 8; TRUE is converted to 1; "This is not a number!" doesn't convert, so it's ignored (note that this is not an error condition).

See also average, count, counta, sum, sumif, sumproduct, sumsq.