PRODUCT (product)

<< 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:

SUM