GCD in WPS Spreadsheet: Find Common Divisors and Equal Whole-Item Groups

• Introduced: documented by 2019-06-24 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: exact supported builds remain 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 native WPS test was performed.

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

The official June 2019 Windows Personal lesson describes 1–255 numeric arguments, truncating fractional inputs. Its worked instructions also demonstrate a referenced cell range. The lesson’s opening says two or more integers, but the formal argument description permits one; the practical grouping examples here use at least two.

The same source documents #VALUE! for nonnumeric arguments and #NUM! for negative arguments. These are historical product-reference rules, not a new native error test or an established current-build maximum. A full numeric-text and mixed-range coercion matrix remains unverified.

Put numeric 54 in A2 and 90 in A3:

=GCD(A2:A3)
=A2/GCD(A2:A3)
=A3/GCD(A2:A3)

Expected results are 18 groups, 3 first-type items per group, and 5 second-type items per group. Every item is used and every group has the same composition.

Nine groups are also possible, with six and ten items per group. GCD returns the greatest feasible group count under these whole-item assumptions, not the number of possible grouping plans.

Add numeric 84 in A4:

=GCD(A2:A4)

Expected result: 6. The per-group quantities are now 9, 15 and 14, from 54/6, 90/6 and 84/6. The former 18-group plan would require 84/18, or approximately 4.666666667, of the third item per group.

Adding a constraint can reduce the common divisor. Do not ignore the extra stock simply because the earlier result gave a more attractive plan. A complete model must include every item type that must be distributed evenly.

For quantities 84 and 126:

=GCD(84,126)
=84/GCD(84,126)
=126/GCD(84,126)

Expected results are 42, 2 and 3, giving ratio 2:3. Keep the reduced quantities numeric if other formulas use them; text 2:3 is a presentation label rather than a pair of numeric cells.

The quantities must use compatible units and be integer counts at the chosen scale. An approximate measured ratio is a different problem from an exact common-divisor calculation.

The dated WPS rule makes =GCD(54.9,90.2) operate on 54 and 90, with expected result 18. It does not round 54.9 to 55.

For measurements 5.4 and 9.0, direct truncation uses five and nine, whose GCD is 1. If the intended common unit is one tenth, explicitly rescale to integer counts 54 and 90 and obtain GCD 18. Changing units deliberately preserves the stated measurement scale; discarding the decimal part does not.

Retain the original values when applying either policy. The fact that the function can truncate a fractional count does not make that count valid for indivisible physical items.

For the positive pair 54 and 90, LCM has independently expected value 270. The identity is:

=GCD(54,90)*LCM(54,90)
=54*90

Both expected results are 4860. This is a small positive-integer consistency check, not a universal guarantee of exact arithmetic for very large inputs.

A direct negative integer, such as -6, falls under the lesson’s documented #NUM! rule. An ordinary nonnumeric argument falls under its #VALUE! statement. Exact ordering of negative-fraction truncation versus validation, zero-only behavior, all mixed-range types and current numeric limits were not established.

GCD answers an equal-group or common-factor question. It does not find the next alignment of two repeating cycles; that is an LCM question. Check the units and the requested outcome before interpreting a perfectly valid divisor as a real-world plan.

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

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