How do I use PRODUCT in Excel?
Use PRODUCT when you want to multiply several values. Enter Target range, Additional range in that order, then add optional arguments when needed.
Excel Function
PRODUCT
Returns product of given numbers.
PRODUCT(number1, [number2], ...)Arguments
number1
RequiredSpecify the first number or range to calculate.
number2
OptionalOptional second argument; leave blank when not needed.
Practice Preview
Use PRODUCT to return the result with these settings (Target range: C2:C8 (Quantity in column C)). You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | 361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | S005 | 150.9 | 6 | 905.4 |
| 7 | ||||
| 8 |
How to Use (Formula)
=PRODUCT(C2:C8)Result
720
Practice This Function
PRODUCT FAQ
Where can I practice PRODUCT?
Use the "Start Function Practice" button to jump straight into PRODUCT drills.
What arguments does PRODUCT use?
The main arguments are Target range, Additional range. Start with the required ones, then add optional arguments if needed.