Returns the result of multiplying a series of numbers together.
PRODUCT(factor1, [factor2, ...])
factor1– The first number or range to calculate for the product.
factor2 ... factor 30– [ OPTIONAL ] – Additional values to multiply by.
If only a single number for
factor1is supplied, PRODUCT returns factor1.
factormay be a number or a range. If a range, empty cells are ignored.
PRODUCTis specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.
SUM: Returns the sum of a series of numbers and/or cells.
QUOTIENT: Returns one number divided by another, without the remainder.
MULTIPLY: Returns the product of two numbers. Equivalent to the '*' operator.
MINUS: Returns the difference of two numbers. Equivalent to the '-' operator.
DIVIDE: Returns one number divided by another. Equivalent to the '/' operator.
ADD: Returns the sum of two numbers. Equivalent to the '+' operator.