Contact
12 programs
Explore the site

PRODUCT Function (LibreOffice Calc)

Math Beginner LibreOffice Calc Introduction not established

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.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by LibreOffice 26.8.1.1; original introduction not established.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **PRODUCT** function multiplies numbers, cell references, and ranges in LibreOffice Calc. It is the multiplicative equivalent of `SUM` and is especially useful when multiplying many values, applying scaling factors, or performing compound calculations. `PRODUCT` is optimized for speed and accuracy, making it preferable to chaining multiple `*` operators.

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:
    • 5
    • A1
    • A1:A10
    • A1; 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
PRODUCT is ideal for compound calculations, scaling factors, and geometric formulas where multiplication must be explicit and reliable.
  • 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.

Reproducible example (tested in LibreOffice Calc)

This standalone example was calculated in LibreOffice Calc 25.2.3.2 and matched the expected value. It is a practical cross-check of one usage, not proof that every example elsewhere on this page is correct.

=PRODUCT(2;3;4)

Expected result: 24.

Multiply numbers or cell ranges.

If the result differs, check the referenced cells, argument separators and number formatting. For more information, consult the LibreOffice Calc official help.