[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
PRODUCT ( argument-list )
Description: Multiplies the numeric values of arguments in argument-list.
Arguments:
|
Name |
Type |
Description |
|
argument-list |
logical, number, text, array, reference |
The arguments in argument-list designate the numbers to be multiplied. Arguments that are numbers, logical values, or text representations of numbers shall be counted. If an argument is an array or reference, only numbers in that array or reference shall be counted. Empty cells, logical values, and text in the array or reference shall be ignored. |
Return Type and Value: number – The product of the values of its arguments.
[Example:
PRODUCT(1) results in 1
PRODUCT(1,2,3,4,5) results in 120
PRODUCT({1,2;3,4}) results in 24
PRODUCT({2,3},4,"5") results in 120
end example]