<< Click to Display Table of Contents >> PRODUCT (product) |
Syntax:
PRODUCT(Number1 [, Number2, Number3 ...])
Description:
Returns the product of the given numbers. Number1, Number2, etc., are the numbers to be multiplied.
Annotation:
When you use this function with cell references or arrays, text strings and logical values are ignored. However, the situation is different if you insert fixed values to it: Here, text strings containing numbers are counted. Furthermore the logical value TRUE is treated as 1 and FALSE as 0. See examples.
Example:
PRODUCT(2, 3, 4) equals 2*3*4, which equals 24
When cells A1 to A3 are filled with the values 2, 3 and 4, the following applies
PRODUCT(A1:A3) equals 2*3*4, which equals 24
Note:
PRODUCT(2, "5", TRUE) equals 2*5*1, that is 10
But: If the cells A1 to A3 are filled with 2, "5" and TRUE, the formula PRODUCT(A1:A3) returns a different result: It returns 2, because strings and truth values are only considered if they are specified as fixed values.
See also: