TRUNC in WPS Spreadsheet: Remove Fractional Digits with an Explicit Precision

• Introduced: documented by 2019-05-22 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: 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.

=TRUNC(number, [num_digits])

number is the value to truncate. num_digits specifies the retained precision; the official WPS lesson explicitly gives a default of 0 and demonstrates leaving that field empty in its function dialog.

The brackets show an optional argument and are not typed into a normal formula. The examples use English names and comma separators. At zero precision, the result is the integer part with fractional digits removed toward zero.

=TRUNC(7.9)
=TRUNC(-7.9)
=TRUNC(-7.9,0)

Expected results: 7, −7 and −7. The omitted and explicit zero precision describe the same control. A negative input does not move down to −8 because truncation is not floor-style rounding.

Enter −4.8, −4, −0.3, 0, 0.3, 4.8 in A2:A7 and fill =TRUNC(A2) down. Expected outputs are −4, −4, 0, 0, 0, 4.

For ordinary decimal controls:

=TRUNC(12.349,2)
=TRUNC(-12.349,2)

Expected results: 12.34 and −12.34. The digits beyond the selected precision are discarded rather than causing an increment in the retained digits.

These are independently derived decimal expectations. They are not native precision benchmarks for values whose binary representation lies extremely close to a cutoff. Retain the original source value when diagnosing a subtle difference.

=TRUNC(-4.8)
=INT(-4.8)

Expected results: −4 and −5. The dedicated WPS INT lesson specifies rounding down to the nearest integer. The TRUNC lesson’s informal comparison describing INT as nearest-integer rounding is inconsistent with that definition and is not used here.

For positive 4.8 the two functions agree at 4, so a negative control is necessary when checking a formula conversion. See INT for the downward-rounding interpretation.

For the numeric input −4.8:

=-4.8-TRUNC(-4.8)

Expected discarded signed fraction: −0.8. For positive 4.8, the corresponding expression gives 0.8. The retained integer plus that signed fraction reconstructs the original value.

This is not automatically the same as MOD with a positive divisor, whose documented remainder convention follows the divisor’s sign. Use the exact operation required by the model rather than treating fractional part and remainder as interchangeable phrases.

Enter 1.29, 1.29 and 1.29 in D2:D4. In E2 enter =TRUNC(D2,1) and fill down. Expected outputs are 1.2, 1.2 and 1.2, totaling 3.6.

The raw total is 3.87. Truncating that total to one decimal instead gives 3.8:

=TRUNC(D2+D3+D4,1)

The two policies differ by 0.2. Decide whether precision is applied before or after aggregation; the function cannot infer that requirement from the source numbers.

A display format can hide decimal places without applying TRUNC to the stored value. Keep raw inputs and calculated outputs separate so a reader can see whether the difference comes from calculation or display.

The cited lesson documents precision and its zero default, but not a complete native error, imported-type or extreme-value matrix. The examples deliberately avoid inferring every negative-precision, invalid-argument or cross-client behavior from another spreadsheet product.

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