PRODUCT in WPS Spreadsheet: Multiply Numeric Ranges and Separate Text from Zero

• Introduced: documented by 2019-06-03 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; no numeric release is stated. This is documentation evidence, not an installed-build guarantee.
• Scope: the exact supported build range is unverified. The Windows lesson does not establish equivalent availability in other WPS clients.
• Checked: October 14, 2026 against function-specific documentation. Examples were independently calculated; no new native WPS test was performed.

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

The June 3, 2019 WPS Windows Personal lesson describes 1–30 arguments. That statement is scoped to the dated lesson; the current build’s maximum has not been independently verified. Do not turn a historical teaching limit into a universal present-day WPS limit.

The same reference says numeric cells in arrays or references are multiplied while text, logical values and empty cells in those ranges are ignored. Its error-related wording is not used here to certify error-containing ranges, which require native verification. The examples use English names and comma separators.

Put numeric 2, 3 and 4 in A2:A4. Then compare:

=PRODUCT(A2:A4)
=PRODUCT(2,3,4)
=2*3*4

All three expected results are 24. A range makes the factors visible and easier to maintain than retyping them in several formulas.

Do not include an already computed subtotal as another factor unless the model actually requires multiplying by it. PRODUCT follows the provided values rather than deduplicating repeated information.

For a fictional unit amount 7.5 and quantity 8:

=PRODUCT(7.5,8)

Expected result: 60. The same relationship can be written as 7.5×8. Keep the meaning and units of each factor explicit; multiplying two unrelated fields does not become meaningful just because the result is numeric.

Create a separate range H2:H5 containing numeric 2, ="3", numeric 4, and a genuinely empty cell. Then:

=PRODUCT(H2:H5)

Expected result: 8, under the documented numeric-range rule. The quoted digit string and empty cell do not supply numeric factors. Deliberately replacing H3 with numeric 3 changes the expected result to 24.

Now place numeric zero in H5. The expected product becomes 0, because a numeric zero is an actual factor. An ignored empty position and a zero are not interchangeable inputs.

This demonstration does not establish an all-empty or all-text range result, nor every directly supplied text-argument conversion. Keep those separate from the explicit numeric controls.

Suppose three fictional sequential adjustment factors are 1.1, 0.9 and 1.2 in K2:K4. Then:

=PRODUCT(K2:K4)

Expected combined factor: approximately 1.188. Applied to starting quantity 100, the result is 118.8. Adding the percentage changes 10%−10%+20% would suggest a factor of 1.2 and result 120, a different calculation.

Multiplication is appropriate because each factor applies to the preceding result. Store the original factors so a later reader can distinguish compounding from a fixed-base adjustment policy.

=PRODUCT(-2,3,4)
=PRODUCT(-2,-3,4)

Expected results: −24 and 24. One negative factor reverses the sign; two negative factors cancel that reversal. Zero, if present as a numeric factor, makes either product zero.

POWER expresses repeated use of the same base more compactly. PRODUCT is useful when the factors come from different cells or a maintained list.

Inspect source types and unintended zeros before changing a correct multiplication formula. A formatted digit string can look numeric while being ignored within a range. Preserve the raw import and use ISNUMBER to investigate deliberately.

The dated source establishes core behavior, not every current-build limit, error convention or extreme-size precision boundary. None of the examples were executed in a native WPS session.

• WPS Academy: PRODUCT lesson, 2019-06-03 (Chinese; Windows Personal scope).
• Editorial testing standards.

The cited product lesson was read directly. Worked outputs are independent expectations, not captured native WPS results or proof of support across all current clients.