LCM in WPS Spreadsheet: Align Integer Cycles and Combine Fractions

• Introduced: documented by 2019-06-19 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.

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

The official June 2019 Windows Personal lesson describes 1–255 arguments and says noninteger inputs are truncated. It documents #VALUE! for nonnumeric arguments and #NUM! for negative inputs. The present guide scopes those statements to that lesson; current build limits and a complete coercion matrix remain unverified.

The examples use positive integer inputs and explicit cell references, English names and commas. Although the lesson allows nonnegative values, it does not explicitly explain the returned result when zero participates, so the cycle examples do not rely on a guessed zero convention.

The multiples of nine begin 9, 18, 27, 36, while those of twelve begin 12, 24, 36, 48. Their first common positive value is 36.

Put numeric 9 in A2 and 12 in A3:

=LCM(A2,A3)

Expected result: 36. By that time the first cycle has repeated four times and the second three times. Multiplying the periods gives 108, also a common multiple but three times later than necessary.

For coprime periods five and seven, the LCM is 35, equal to their product. One agreeing product example does not justify multiplying every pair of periods.

Add numeric 15 in A4:

=LCM(A2,A3,A4)

Expected result: 180, with repeat counts 20, 15 and 12 for periods 9, 12 and 15. The earlier 36-unit alignment fails the third cycle because 36 is not a multiple of 15.

All cycles must start at the same reference instant for this interpretation. A cycle beginning later introduces a phase offset; its alignment cannot be solved merely by reusing the same LCM value.

For one ninth plus one twelfth:

=LCM(9,12)
=LCM(9,12)/9+LCM(9,12)/12

Expected outputs are denominator 36 and numerator 7, from 4+3. The sum is 7/36, approximately 0.194444444. Numerator and denominator have GCD one, so this fraction is already reduced.

For one sixth plus one fifteenth, the common denominator is 30 and the numerator is again 7, from 5+2. These are rational-number constructions, separate from formatting a decimal result to look like a fraction.

The documented historical rule gives =LCM(9.8,12.6) the integer inputs nine and twelve, with independently expected result 36. Rounding them first to ten and thirteen would produce 130 instead, a different calculation.

Do not use truncation as an invisible repair for measured cycle lengths. If periods are recorded in tenths, rescale deliberately into a common integer unit before using an integer-multiple model. Keep the source measurements and the conversion factor visible.

For positive integer inputs:

=9/GCD(9,12)*12

Expected result: 36. GCD gives three, and dividing out that shared factor avoids counting it twice in the product.

The corresponding identity GCD(9,12) times LCM(9,12)=9 times 12 gives 108 on both sides. These small controls explain the mathematics; they do not certify native precision or overflow safety for every large intermediate result.

Nine hours and twelve minutes are not periods nine and twelve in one common unit. Converting nine hours to 540 minutes gives =LCM(540,12), whose expected result is 540 minutes. The chosen unit materially changes the inputs.

Calendar months, weekends and timezone transitions do not form simple fixed-length integer cycles. Apply calendar-specific rules separately rather than treating a correct LCM as a scheduling solution for those cases.

Direct negative integers and nonnumeric arguments are covered by the dated lesson’s error statements. Exact zero behavior, negative fractional validation order, mixed-range conversions and current WPS client limits are outside the checked controls.

• WPS Academy: LCM lesson, 2019-06-19 (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.