PRODUCT in Collabora Office: Multiply Ranges and Build Growth Factors

• Introduced: documented by Collabora Office 26.04; the original introduction release is not established.
• Availability: PRODUCT is documented in the official 26.04 Calc Help.
• Scope: desktop Calc documentation; separately deployed Online and mobile versions have not been verified.
• Checked: October 13, 2026, against the official PRODUCT reference. Documentation check; not a native application test. Expected examples are independently calculated.

=PRODUCT(number1; [number2]; ...)

The official reference permits numbers, cell references and ranges, with up to 255 argument positions. A range can contain many cells; the argument-position count is not the same as the number of cells in a supplied range.

For referenced data ranges, the documentation says text and empty cells are ignored. A numeric zero is not empty: multiplying by zero changes the result to zero. This difference can be important when blank imports and zero measurements are mixed.

Enter 3, 4 and 5 in B2:B4. In D2 use:

=PRODUCT(B2:B4)

Expected result: 60. The manual check is 3×4×5. The result is not the sum of the three inputs, which would be 12.

If the cells represent length, width and height in metres, the product represents cubic metres. Keep units consistent and label the result explicitly.

=PRODUCT(B2:B4;2)

Expected result: 120. The range’s product of 60 is multiplied by two. This is useful when several component factors live in cells while one fixed quantity is supplied directly.

For a maintained workbook, consider storing a business multiplier in a labeled cell instead of embedding it in many formulas. If that cell must stay fixed when a formula is filled down, use an absolute reference such as $F$1.

On a separate sheet or after saving the original inputs, compare:

=PRODUCT(3;0;5)
=PRODUCT(-3;4;5)
=PRODUCT(-3;-4;5)

Expected results: 0, -60, and 60. One negative factor makes a nonzero product negative; two negative factors make it positive. The presence of a zero makes the product zero regardless of the other finite factors.

A zero may be a legitimate quantity, but it can also be an incorrectly coded missing value. PRODUCT does not decide which interpretation is appropriate.

In H2:H5 enter 2, the text Pending, a genuinely blank H4, and 3. Then enter:

=PRODUCT(H2:H5)

Expected result: 6 under the documented range rule. The text and blank do not become extra factors. Change H4 from blank to the numeric value 0; the expected result becomes 0.

This test concerns values stored in referenced cells. It does not establish that arbitrary text supplied directly as a function argument follows every same coercion rule. Avoid mixing the two cases in compatibility claims.

Suppose three successive changes are +10%, -5% and +20%. Store the multiplicative factors 1.10, 0.95 and 1.20 in J2:J4.

=PRODUCT(J2:J4)
=PRODUCT(J2:J4)-1

Expected results: 1.254 and 0.254, or a cumulative increase of 25.4%. Applied to a starting quantity of 100, the result is 125.4.

Multiplying raw rates 10%, -5% and 20% would answer a different question. The growth factor for each period is one plus that period’s rate. Adding the three rates is also a different model from successive multiplication.

PRODUCT combines all supplied factors into one product. SUMPRODUCT forms corresponding products and adds them. If A2:A3 is 2,3 and B2:B3 is 4,5, multiplying all four numbers gives 120, while the sum of paired products is 2×4+3×5 = 23.

Choose the operation from the intended mathematics rather than from the similarity of function names.

A product unexpectedly equal to zero calls for a zero-value check. A surprisingly small or large result often indicates a rate-versus-factor or unit mistake. Inspect the factors individually before wrapping errors or rounding away the symptom.

For a native test, record the Collabora build and verify the range, zero, sign and text-in-range cases. No native run was performed here. The results are independently calculated and matched to the official documented range behavior.

• Collabora Office 26.04: PRODUCT, checked October 13, 2026.
• Editorial standards.