PRODUCT


Multiplies all the numbers given as arguments and returns the product.

Syntax:

PRODUCT(number1, number2, ... number30)

number1 to number30 are up to 30 numbers or ranges/arrays of numbers whose product is to be calculated.
PRODUCT returns number1 * number2 * number3 * ........PRODUCT ignores any text or empty cell within a range or array.

Example:

PRODUCT(2; 3; 4)
returns 24 (2 * 3 * 4).
PRODUCT(A1:A2)
where A1 and A2 contain 3 and 5, returns 15 (3 * 5).






 
Created with Zapof