Functions
PRODUCT
Product of arguments
Try it
When to use it
When should I use PRODUCT instead of just typing * between values?
Use PRODUCT when you want to multiply many values or a whole range at once; the * operator is clearer for a couple of fixed numbers, but PRODUCT scales to lists and arrays without repeating the operator.
Does PRODUCT ignore text and blank cells?
Yes. PRODUCT multiplies only the numeric values it finds and skips text and empty cells, so stray labels in a range will not break the calculation.
Use cases
Apply a markup to a base price
Compound a series of growth factors
Used in
Syntax
PRODUCT(value1,...)Examples
=PRODUCT(5) // => 5
=PRODUCT(1,2,3,4,5) // => 120