Skip to content
Excel

PRODUCT function in Excel

Multiplies its arguments

=PRODUCT(number1, [number2], ...)

PRODUCT syntax and parameters

Two arguments, one required.

  • number1anyRequired

    The first number or range that you want to multiply.

  • number2anyRepeating

PRODUCT examples

Formulas you'll actually reuse.

  1. A column of factors multiplied — e.g. chained growth rates:

    =PRODUCT(B2:B5)

    Result1.2155

  2. Price × (1 − discount) × (1 + tax) in one call:

    =PRODUCT(B2, 1 - C2, 1 + D2)

    Result23.79

PRODUCT in Google Sheets

Same name — your formula ports as-is.

Try PRODUCT in the playground

Edit the example — nothing to install.

Preloaded with the PRODUCT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.