next up previous contents index
Next: PROPER Up: A Function Reference Previous: PRICEMAT

PRODUCT

 

Syntax: @PRODUCT(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

@PRODUCT multiplies all the numeric elements of the argument list together, ignoring empty and non-numeric values, and returns the product.

Examples:

@PRODUCT(6, 5, 8, 2) = 480

@PRODUCT(A1..A3) = 25.1327, where A1..A3 = 2, @PI, 4


next up previous contents index
Next: PROPER Up: A Function Reference Previous: PRICEMAT

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999