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.

See alsoQUOTIENTSUMAdd and edit formulasReview formula errors and follow best practicesRefer to cells in formulas
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.