INT in WPS Spreadsheet: Round Down to Whole Numbers Without Losing the Sign Rule

• Introduced: documented by 2019-05-14 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; WPS 2019 explicitly named in the lesson. 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.

=INT(number)

The required argument is the real number to round down. The WPS INT lesson explicitly describes downward integer rounding and names WPS 2019 in its demonstration.

A separate WPS TRUNC lesson loosely describes INT as rounding to the nearest integer. That comparison is misleading; this guide follows INT’s own downward-rounding definition. Use English names and comma separators in the controls below.

Enter −3.7, −3, −0.2, 0, 0.2, 3.7 in A2:A7. In B2 enter =INT(A2) and fill down.

Expected outputs are −4, −3, −1, 0, 0, 3. Whole-number inputs remain unchanged. A negative fractional input moves to the next integer below it rather than toward zero.

The nonzero fractions are important test cases. An example containing only positive whole numbers cannot show the difference between floor-style rounding and truncation.

=INT(-3.7)
=TRUNC(-3.7)

Expected results: −4 and −3. TRUNC removes the fractional part at its default precision. For positive 3.7, both functions give 3, so positive-only controls can conceal a mistaken substitution.

Neither function performs ordinary nearest-integer rounding. At positive 3.7, that separate rounding rule would select 4.

For a fictional numeric index, define each bin by its lower multiple of ten. Enter −11, −10, −1, 0, 9, 10 in D2:D7 and calculate:

=10*INT(D2/10)

Expected lower bounds are −20, −10, −10, 0, 0, 10. Each input lies at or above the selected bound and below bound+10. For instance, −11 belongs to the interval from −20 inclusive to −10 exclusive.

Using truncation instead would place −11 at lower bound −10, which is greater than the input and violates this stated bin rule. The desired interval convention, not the word integer alone, decides which function is appropriate.

The official WPS MOD lesson documents the identity MOD(n,d)=n-d*INT(n/d). For n=−17 and d=5:

=-17-5*INT(-17/5)
=MOD(-17,5)

Expected results: 3 and 3. The floor quotient is −4, and −17−5×(−4)=3. MOD uses the divisor’s sign for a nonzero remainder under that documented rule.

Do not replace INT with QUOTIENT in this identity for all signs. QUOTIENT removes the fractional part of the quotient and therefore supplies a different integer when the division result is negative and nonintegral.

An INT result is a calculated number, not a change in the number of displayed decimal places. Keep the original value beside the integer output when reviewing a transformation. A shortened display alone does not prove that the source was rounded down.

The same operation can have different interpretations in a count, an index or a measurement. Negative quantities may be allowed in one model and invalid in another; INT does not validate the business meaning of its input.

Check the sign, the original decimal value and whether the intended rule was downward rounding, truncation or nearest-integer rounding. The dated lesson does not provide a complete text-coercion, native error or extreme-magnitude matrix.

The mathematical controls here are independently calculated from the documented definition. They do not establish the exact first supported release, current build limits or equivalent behavior in every WPS client.

• WPS Academy: INT lesson, 2019-05-14 (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.