How to Use PRODUCT Function in Excel | Excel Formula Guide

Learn how to use the PRODUCT function in Excel to multiply values easily. Learn syntax, examples, and tips for efficient calculations in spreadsheets.

PRODUCT function

• The PRODUCT function multiplies all the numbers given as arguments and returns the product.
• The PRODUCT function is useful when you need to multiply many cells together.

For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.

=Product(5,2)
=Product(C6:E6)

• Video Tutorial: PRODUCT function in excel

further reading:

• PRODUCT function - Microsoft Support