PRODUCT Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Troubleshooting

Multiply several numeric factors without writing a long chain of * operators. For example, =PRODUCT(3,5,2) has an independently calculated expected result of 30.

PRODUCT belongs to the math and trigonometry functions. It multiplies all numeric factors supplied to the function. A contiguous numeric range is convenient for inventory carton quantities, scaling factors, and successive percentage changes. Multiplying factors differs from summing values: a zero factor makes a mathematical product zero, and two negative factors yield a positive product.

Best-fit uses: product of dimensions; cumulative change factors such as 1.05 and 0.98; successive multipliers recorded as numeric cells. Not a direct substitute for SUMPRODUCT: PRODUCT multiplies all selected factors together; SUMPRODUCT adds corresponding per-row products across aligned arrays. ONLYOFFICE independently documents SUMPRODUCT and its specific nonnumeric treatment; don’t transfer those rules to PRODUCT.

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

In this notation, square brackets such as [number2] in the vendor’s syntax description mean an optional argument, not characters to type into a formula. The official help describes up to 255 numeric values in its argument description. This is not evidence that a 255-cell range is the worksheet size limit: do not conflate argument entries with the number of cells represented by a range. The documentation excerpt does not separately enumerate coercion rules for booleans, blank cells, numeric text, quoted text, or propagated errors.

Research access date: 2026-10-13. The formula name and signature on this page come from the official, English-language ONLYOFFICE reference. That page does not identify the first product release containing this function and does not provide a Desktop-versus-browser capability matrix. Therefore, the guide describes documented ONLYOFFICE Spreadsheet Editor behavior, not an assertion that every desktop, self-hosted, or cloud edition at every version works identically.

ONLYOFFICE announced Docs 10.0 on October 10, 2026. That release announcement is not evidence that this individual function was introduced in 10.0. Before relying on the formula in production, verify the actual version in use and test the examples in that installation; native spreadsheet execution was not performed.

The examples use English function names, commas between arguments, and a period as the decimal separator. ONLYOFFICE documents a Formula Language setting and Region and decimal/thousands separator options in File → Advanced Settings. Those instructions do not establish one universal formula-argument separator for all locales: if your installation rejects the illustrated punctuation, check its formula input and regional settings rather than blindly copying the text. Keep values such as 1.5 numeric under the selected locale, not imported text.

Validation method: the values called expected below were independently computed with elementary arithmetic (and, where needed, a reference numerical π constant). They were not read from a running ONLYOFFICE Desktop or web instance. No screenshots, imported workbook tests, or installation-specific error messages are claimed.

1. Open a blank sheet in ONLYOFFICE Spreadsheet Editor using a version where the function is available.
2. Leave any previously used ranges clear. Enter the example numbers as numeric values in the precise cells below. If your decimal separator is not a period, adapt the numeric entry to your installed region.
3. In an unused location (for example H2, H3, H4, etc.), enter one formula per cell from the table. Press Enter according to your application’s usual workflow.
4. Compare the result with the expected value, allowing for displayed decimal rounding where the table says “approximately.” The table is an independent mathematical prediction, not the result of a native editor test.
5. If the displayed result differs, first check your numeric inputs, active formula language/region, and the actual Desktop/web version. Record the observed behavior rather than changing documented syntax to fit a different spreadsheet.

Worked formulas with reproducible expected answers

Compound returns without summing rates

Put the four multipliers in B2:B5 exactly as shown. =PRODUCT(B2:B5) represents (1.05 × 0.98 × 1.08 × 1.02) = 1.1335464; a 1,000-unit starting amount becomes 1,133.5464 units, before applying any currency rounding policy. A compound 13.35464% gain differs from simply adding 5%, −2%, 8% and 2% (13%). Do not silently assume that a changing base can be handled as a sum of percentage points.

Interpreting zero and sign changes

When A5 equals numeric zero, =PRODUCT(A2:A5) is expected 0, even though the other factors are positive. If zero means missing data rather than a genuine multiplier, fix that data-quality issue before using the function. =PRODUCT(A2:A3,A6) is expected −60 because the single negative factor changes the product’s sign. Repeated negative factors behave according to ordinary multiplication.

PRODUCT versus multiplication operators

=A2*A3*A4 and =PRODUCT(A2:A4) should be numerically equivalent for the supplied numeric cells. PRODUCT becomes easier to maintain when you have many contiguous factors; direct multiplication may be easier when two named cells are separated widely. If adding a new row to a dataset, inspect whether your range reference includes that row—the function does not itself guarantee your reference expands.

Error evidence limitation: ONLYOFFICE’s short PRODUCT function page does not document a complete error-code table for malformed formulas or every mixed input type. The table distinguishes safe mathematical reasoning from untested application behaviour; it does not invent #VALUE!, #NUM!, or other specific returns for this function. Check native responses before adding an error-output screenshot or support claim.

Does PRODUCT add numbers? No. The function multiplies them. For a sum, use SUM.

Can I use it to compound returns? Yes, mathematically: multiply successive factors such as 1.05, 0.98, etc. The result is a multiplier; subtract 1 to obtain an overall fractional return.

Does PRODUCT treat text exactly like Excel? That claim is not supported by the short ONLYOFFICE source. Use typed numeric cells for the reproducible examples and test imported data in the target version.

How is PRODUCT different from SUMPRODUCT? PRODUCT computes one combined multiplication; SUMPRODUCT multiplies corresponding entries and then adds those products. See ONLYOFFICE’s SUMPRODUCT documentation.

The function also has a same-name counterpart in widely used spreadsheet software, but matching names are not proof of identical coercion, locale, error, recalculation, or precision behavior. For ONLYOFFICE itself, the syntax and principal purpose are supported by its own function reference. Validate any important shared workbook in the particular version of ONLYOFFICE Desktop or browser editor to which it will be delivered, particularly if it was authored with a non-English formula language or contains blank cells, text or errors.

• Official documented: function purpose, argument order and optionality as shown, and any explicit numeric limit cited above.
• Independently calculated: every numeric example marked expected, using the cell setup in this guide.
• Native execution: not performed in ONLYOFFICE Desktop or web, so exact displayed precision and undocumented boundary/error responses remain unconfirmed.

1. Official ONLYOFFICE PRODUCT help — formula syntax and core documented meaning; unversioned function reference.
2. ONLYOFFICE Spreadsheet Editor advanced settings — formula language, region and decimal/thousands separators.
3. ONLYOFFICE Docs 10.0 announcement, dated October 10, 2026 — broad release context only, not the function’s introduction version.
4. Official ONLYOFFICE SUMPRODUCT help — related documentation checked 2026-10-13.
5. Official ONLYOFFICE SUM help — related documentation checked 2026-10-13.