PRODUCT Function (LibreOffice Calc)
The PRODUCT function in LibreOffice Calc multiplies numbers, cell references, and ranges. It is the multiplicative counterpart to SUM and is essential for compound calculations, scaling, and array-based math.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✔ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
What the PRODUCT Function Does ▾
- Multiplies numbers, cells, and ranges
- Supports multiple arguments
- Treats empty cells as 1
- Ignores text values
- Useful for scaling, compounding, and array math
It is designed to be fast, reliable, and universally compatible.
Syntax ▾
PRODUCT(number1; [number2]; ...)
Arguments
- number1, number2, …
Numbers, cell references, or ranges to multiply.
Examples:5A1A1:A10A1; C1; E1
Basic Examples ▾
Multiply a range
=PRODUCT(A1:A5)
Multiplies all values from A1 to A5.
Multiply individual values
=PRODUCT(2; 3; 4)
Returns 24.
Multiply mixed references
=PRODUCT(A1; A2; 10)
Multiplies two cells and a constant.
Equivalent using *
=A1 * A2 * A3
Same result, but less scalable.
Advanced Examples ▾
PRODUCT with scaling
=PRODUCT(A1:A10; 1.13)
Applies a 13% increase to the product of A1:A10.
PRODUCT for compound growth
=PRODUCT(1 + B1:B5)
Computes cumulative growth across multiple periods.
PRODUCT with ABS
=PRODUCT(ABS(A1:A10))
Multiplies magnitudes (requires array entry).
PRODUCT with conditional logic
=PRODUCT(IF(A1:A10 > 0; A1:A10; 1))
Multiplies only positive numbers.
PRODUCT for geometric mean (manual)
=PRODUCT(A1:A10)^(1/COUNT(A1:A10))
Equivalent to GEOMEAN (not built into Calc).
PRODUCT for unit conversions
=PRODUCT(A1; 0.3048)
Converts feet to meters.
PRODUCT with SUMPRODUCT
=PRODUCT(SUMPRODUCT(A1:A5; B1:B5); 1.05)
Applies a 5% adjustment to a weighted sum.
Common Errors and Fixes ▾
PRODUCT returns 0 unexpectedly
Possible causes:
- One of the values is zero
- A cell contains text that looks like a number
- A referenced cell contains an error
Fix:
Convert text to numbers using:
Data → Text to Columns → OK
PRODUCT returns Err:502
Occurs when:
- A range reference is malformed
- An argument is invalid
- A semicolon or colon is misplaced
PRODUCT ignores some values
Cause:
- PRODUCT ignores text and empty cells
- PRODUCT treats empty cells as 1
Fix:
Use VALUE() or double‑unary (–) to coerce text to numbers.
Best Practices ▾
- Use PRODUCT instead of chaining
*for readability - Use PRODUCT with array formulas for compound logic
- Use PRODUCT for geometric calculations and scaling
- Avoid mixing text and numbers in the same range
- Use PRODUCT with IFERROR to sanitize data
Related Patterns and Alternatives ▾
- Use SUMPRODUCT for weighted multiplication
- Use SUM for additive aggregation
- Use POWER for exponentiation
- Use EXP for natural exponential growth
- Use A1 * A2 * A3 for quick inline multiplication
By mastering PRODUCT and its combinations with other math functions, you can build precise, scalable models in LibreOffice Calc that handle multiplicative logic cleanly and efficiently.