FACT in WPS Spreadsheet: Factorials, Ordering and Truncated Inputs

• Introduced: documented by 2019-06-21 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; no numeric release is stated in the edition metadata.
• Scope: exact current 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.

=FACT(number)

Enter numbers 0, 1, 4, 4.8 and 5 in A2:A6. In B2 enter =FACT(A2) and fill down. Independently calculated results are:

The noninteger result uses 4, not 5. FACT’s input conversion does not round to the nearest whole number. The source explicitly demonstrates 4.8 and explains the zero case.

Examples use English function names and comma separators. Use numeric cells and keep output formulas outside the input column. These results are independent calculations, not captured WPS execution.

Suppose five distinct presentations must occupy five different time slots, with no other restrictions:

=FACT(5)

There are 120 possible orders: five choices for the first slot, four for the next, then three, two and one. For three presentations, the count is 6. Label them A, B and C to enumerate ABC, ACB, BAC, BCA, CAB and CBA.

This model treats each object as distinct and every order as permitted. Identical objects, fixed positions or prohibited neighbors require a different counting model; a factorial alone does not apply those restrictions.

Eight distinct candidates can fill three distinct roles, with no candidate repeated:

=FACT(8)/FACT(8-3)

Expected result: 336, also obtained from 8*7*6. The numerator counts complete orders; dividing by the factorial of the five unused positions removes their irrelevant order.

Choosing three people without assigning roles instead gives:

=FACT(8)/(FACT(3)*FACT(8-3))

Expected result: 56. Dividing by FACT(3)=6 removes the six role orders within each group. COMBIN expresses that unordered selection directly.

Arrange five labels containing three A labels and two B labels:

=FACT(5)/(FACT(3)*FACT(2))

Expected result: 10. Swapping two identical A labels or two identical B labels creates no new visible arrangement. The denominator removes those duplicate counts.

Contrast that with five genuinely distinct labels, which have 120 orders. The input numbers describe multiplicities, so validate that they are whole counts before using them. MULTINOMIAL provides a related factorial-ratio operation.

=FACT(5.9)
=FACT(5)
=FACT(6)

Expected results are 120, 120 and 720. A decimal count imported from another process can therefore produce a plausible integer answer without representing the intended problem. If only whole counts are valid, validate that rule before calling FACT rather than treating truncation as data repair.

For positive integers, FACT(n)/FACT(n-1)=n is a useful modest-size control. At n=6 the ratio is 720/120=6. Keep this check within a small, ordinary range; cancellation in an algebraic expression does not prevent intermediate factorials from becoming too large.

The WPS lesson requires a nonnegative input. It does not establish a complete error-code, overflow or precision table, so this guide does not assign a native error to every negative, blank or text case or promise exact large factorials. Zero is separately documented, not inferred from an empty spreadsheet cell.

FACTDOUBLE multiplies alternating integers and has a different meaning. For example, the mathematical 6 double factorial is 48, whereas 6 factorial is 720. Neither name means multiplying the ordinary factorial by two.

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

The direct WPS product lesson supports the stated function scope. Worked outputs are independent expectations, not captured native results or proof of support across all current WPS clients.