Formulas and Functions
PRODUCT
The PRODUCT function returns the product of a collection of number values.
To learn the basics about using formulas and functions, see Formulas overview and Functions overview.
PRODUCT(num-value, num-value…)
num-value: A number value or collection containing number values.
num-value…: Optionally include one or more additional number values or collections of number values.
Notes
Empty cells included within the values are ignored and do not affect the result.
Examples |
|---|
=PRODUCT(2, 4) returns 8. =PRODUCT(0.5, 5, 4, 5) returns 50. |