PRODUCT multiplies all the numbers you give it and returns a single result. It can take individual numbers, cell references or ranges, making it quicker than typing a long multiplication formula.
=PRODUCT(number1, [number2], …)What does PRODUCT do?
The PRODUCT function is Excel's dedicated tool for multiplication. Instead of writing =A2*B2*C2*D2, you can write =PRODUCT(A2:D2) and let Excel handle the work. It lives in the Math & trigonometry category and accepts up to 255 arguments, each of which can be a number, a cell reference or a range.
Multiplication shows up everywhere in office work: calculating total cost from quantity and unit price, applying a chain of percentage changes, working out compound interest, or scaling a budget by several factors. PRODUCT keeps those formulas short and readable, which reduces typos and makes your spreadsheets easier to audit.
Imagine you are pricing a bulk order. You have a quantity, a unit price, a discount multiplier and a tax multiplier. With PRODUCT you can multiply all four in one clean formula, and if any input changes you only update the cell, not the formula. That is the practical value: fewer mistakes and faster edits.
When to use PRODUCT
- Calculating total cost from quantity, unit price and tax rate
- Applying a series of percentage changes to a starting value
- Working out compound growth over several periods
- Scaling a budget by multiple adjustment factors
- Finding the volume of a box from length, width and height
- Converting units through a chain of multipliers
PRODUCT syntax
=PRODUCT(number1, [number2], …)| Argument | Required? | What to enter |
|---|---|---|
number1 | Required | The first number, cell reference or range to multiply. For example, B2 or B2:D2. |
number2 | Optional | Additional numbers, cell references or ranges to multiply. You can supply up to 255 arguments in total. |
What it returns: A single number equal to the product of all supplied numeric values. Empty cells, text and logical values inside ranges are ignored; direct text or logical arguments cause an error.
PRODUCT examples
1 Multiply three plain numbers
This is the simplest use: multiply three constants directly in the formula. The goal is to confirm that PRODUCT behaves like a chain of asterisks. Excel multiplies 2 by 3, then by 4, and returns 24. No cell references are needed, which makes it handy for quick checks.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Value | |||
| 2 | Length | 2 | 24 | ||
| 3 | Width | 3 | |||
| 4 | Height | 4 | |||
| 5 |
2 Multiply values in a single row
Here the three dimensions of a box sit in cells B2, C2 and D2. The formula =PRODUCT(B2:D2) multiplies length by width by height in one step. Excel reads the range left to right and returns 120, the volume in cubic units. If any dimension changes, the result updates automatically.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Box | Length | Width | Height | |||
| 2 | Box A | 5 | 4 | 6 | 120 | ||
| 3 |
3 Calculate total cost with quantity, price and tax
A stationery order has a quantity, a unit price and a tax multiplier. The formula =PRODUCT(B2:D2) multiplies 12 by 4.5 by 1.2 and returns 64.8. This gives the total cost including tax without writing a long multiplication chain. Change the quantity and the total recalculates instantly.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Product | Quantity | Unit Price | Tax Multiplier | |||
| 2 | Notebook | 12 | 4.5 | 1.2 | 64.8 | ||
| 3 |
4 Apply two percentage changes to a starting value
A price of 200 is increased by 10% and then reduced by 5%. The multipliers are 1.1 and 0.95. The formula =PRODUCT(B2, C2, D2) multiplies 200 by 1.1 by 0.95 and returns 209. This shows how PRODUCT chains percentage changes cleanly. You can add more periods by extending the range.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Stage | Starting Value | First Change | Second Change | |||
| 2 | Price | 200 | 1.1 | 0.95 | 209 | ||
| 3 |
5 Compound growth over three years
An investment of 1000 grows by 5%, then 4%, then 3% over three years. The growth factors are 1.05, 1.04 and 1.03. The formula =PRODUCT(B2:D2) multiplies them all and returns 1124.76. This is faster and less error-prone than writing =B2*C2*D2. It also makes the assumption visible: each cell is a yearly multiplier.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Year | Start Amount | Year 1 Factor | Year 2 Factor | Year 3 Factor | |||
| 2 | Investment | 1000 | 1.05 | 1.04 | 1.03 | 1124.76 | ||
| 3 |
Common PRODUCT errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | One of the direct arguments is text that cannot be converted to a number, such as =PRODUCT("abc", 2). | Remove or correct the text argument, or reference a cell that contains a number. |
| #VALUE! | A direct logical value such as TRUE or FALSE is supplied as an argument. | Convert the logical value to 1 or 0, or place it in a cell and reference the cell. |
| Wrong result (0) | One of the referenced cells is empty or contains 0, and PRODUCT treats blanks as ignored but a zero makes the whole product zero. | Check the range for zeros or blanks and replace them with the correct multiplier, often 1. |
| #NAME? | The function name is misspelled, for example =PRODCUT(...). | Type =PRODUCT( and let Excel's formula suggestions complete the name. |
Tips for using PRODUCT
- Use a range like
B2:D2instead of listing cells one by one; it is shorter and easier to extend. - Remember that blank cells inside a range are ignored, but a zero will make the entire product zero.
- For percentage changes, store the multiplier (1.1 for +10%, 0.9 for -10%) rather than the percentage itself.
- Combine PRODUCT with ROUND to control decimal places, for example
=ROUND(PRODUCT(B2:D2), 2). - If you need to multiply only cells that meet a condition, use SUMPRODUCT or array logic instead.
- Label your multiplier columns clearly so readers understand why the product makes sense.
Frequently asked questions
What is the difference between PRODUCT and using the asterisk?
They give the same result for numbers, but PRODUCT can take a whole range as one argument, which keeps formulas shorter and easier to read.
Does PRODUCT work with blank cells?
Yes. Blank cells inside a referenced range are ignored, so they do not affect the result. A cell containing zero, however, will make the whole product zero.
Can PRODUCT multiply text that looks like a number?
Text inside a range is ignored, but text supplied directly as an argument causes a #VALUE! error. Convert text numbers to real numbers first.
How many arguments can PRODUCT accept?
Up to 255 arguments in total, and each argument can be a number, a cell reference or a range.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. PRODUCT reference