ExcelFlux

PRODUCT function

Multiplication — its arguments.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Multiply quantity, packs and unit factors. A zero factor makes the product zero.

A worked example from the workbook

RowABC
6Period 1Period 2Period 3
7254
8170
9-243
Record 1
=PRODUCT(A7:C7)

Expected result40

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=PRODUCT(4,6,5)
Turkish Excel · tr-TR
=ÇARPIM(4;6;5)

Expected result

120

Worked examples

Multiply quantity, packs and unit factors. A zero factor makes the product zero.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Period 1 Period 2 Period 3
7 2 5 4
8 1 7 0
9 -2 4 3
Case Formula Expected result
Record 1 =PRODUCT(A7:C7) 40
Record 2 =PRODUCT(A8:C8) 0
Record 3 =PRODUCT(A9:C9) -24
Microsoft Excel reference