FACT in Collabora Office: Factorials, Integer Conversion and Large-Value Limits

• Introduced: documented by Collabora Office 26.04; the original introduction release is not established.
• Availability: FACT is documented in the official 26.04 Calc Help.
• Scope: desktop Calc documentation; separately deployed Online and mobile versions have not been verified.
• Checked: October 13, 2026, against the official FACT reference. Documentation check; not a native application test. Expected examples are independently calculated.

=FACT(integer)

The official documentation establishes FACT(0)=1, explains that noninteger numeric inputs are reduced to their floor integer value, and warns about negative inputs and excessively large results. For ordinary counting applications, validate that the input is a nonnegative integer before calculation.

A decimal that accidentally reaches FACT is not rejected merely because it contains a fractional part. That makes validation important when the input is intended to be a count of people, objects or positions.

Enter 0, 1, 3, 5 and 6 in A2:A6. In B2 enter =FACT(A2) and fill down.

For 5, the independent calculation is 1×2×3×4×5 = 120. Zero factorial is defined as one; it is not a product that the spreadsheet has rounded from zero.

Five distinct objects can be placed in five distinct positions in:

=FACT(5)

Expected result: 120 arrangements. There are five choices for the first position, four for the second, and so on.

This model assumes the objects are distinguishable and every ordering is allowed. If some objects are identical, or certain positions have restrictions, a plain factorial overcounts. Document those assumptions before using the result as a planning estimate.

=FACT(5.9)

Expected result: 120, because the documented conversion uses 5. It does not calculate a smooth extension of factorial to 5.9 and does not round 5.9 to six.

If the original input was meant to be six people, this apparently reasonable result is a silent data problem. A validation rule should reject fractional people rather than relying on FACT to guess what was intended.

Suppose six positions contain three A labels, two B labels and one C label. The number of distinct label arrangements is:

=FACT(6)/(FACT(3)*FACT(2)*FACT(1))

Expected result: 60. Six distinct objects would have 720 orders, but permutations among the three identical As and among the two identical Bs do not create new label arrangements. Dividing by 6×2×1 removes those repetitions.

This is a mathematical application of factorial, not a special mode inside FACT. The repeated counts must sum to the total number of positions. If they do not, the formula can still calculate a number that has no valid interpretation for the stated problem.

For choosing two distinct items from a set of five without caring about order:

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

Expected result: 10. Compare with the dedicated COMBIN function for a clearer expression of that task. Choosing items and arranging all items are different counting problems.

The Collabora 26.04 reference identifies values above 170 as beyond the documented FACT limit and describes an error for negative integer input. Keep large-count boundary checks separate from the ordinary example table. This guide has not executed those error probes in a native Collabora build.

Factorials grow very quickly. Even before the function’s documented upper limit, a large displayed value should not be mistaken for an exact integer represented with unlimited precision. Avoid building a formula out of huge intermediate factorials merely because its final mathematical result is small.

Do not automatically replace a factorial error with zero. Zero could be interpreted as “no possible arrangements,” while the real problem is an invalid argument or an unrepresentable intermediate result.

Check that the input represents a count, is nonnegative, has no fractional part, and is within the intended range. Check whether order matters and whether repeated labels have been accounted for. A correct factorial calculation can still answer the wrong counting question.

For native validation, record the exact Collabora version and verify the table, the fractional case and the repeated-label calculation. The answers above were independently calculated; no application execution is claimed.

• Collabora Office 26.04: FACT, checked October 13, 2026.
• Editorial standards.