WPS Sheets TRUNC helps you truncate numbers to a specified number of decimal places without rounding; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
| Version limits | None | Available in the current WPS Sheets environment |
| Membership limits | None | Function input and syntax lookup are available directly |
About This Feature
Overview
TRUNC is a built-in function in WPS Sheets on Windows that truncates a number to a specified number of decimal places without rounding. It is useful for financial value trimming, report display cleanup, and repeated formula entry in spreadsheets.
Core tasks include:
- Insert the TRUNC function from the Insert Function dialog when you want guided parameter entry.
- Type
=TRUNC(...)directly in a cell or the formula bar for faster formula input. - Review the syntax
TRUNC(number, [num_digits])and parameter meanings before applying the formula.
System Requirements
| Item | Requirement |
|---|---|
| OS | A Windows device that can run WPS Office |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory internet connection is required for local formula entry; internet access is needed for downloads or online help |
| Other | You need to open WPS Sheets and edit worksheet cells |
Download & Installation
| Item | Notes |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Open WPS Sheets and confirm that the Formula tab, formula bar, and fx button are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports TRUNC(number, [num_digits]) in WPS Sheets, with entry through Insert Function or direct formula typing. | Excel provides TRUNC(number, [num_digits]) to remove the fractional part and optionally control truncation precision. | Google Sheets provides TRUNC(value, [places]) and states that it truncates without rounding. | Notion formulas include numeric functions such as round, floor, and ceil, but its official formula reference does not list a same-name TRUNC function. | Adobe Acrobat JavaScript documentation focuses on scripting and PDF automation rather than spreadsheet cell formulas such as TRUNC. |
| WPS Advantages | Advantage: WPS Sheets on Windows supports both guided insertion through the function dialog and direct formula entry in cells or the formula bar, which fits both new and experienced spreadsheet users. | Compared with WPS: Excel offers the same function, but the referenced page focuses on syntax and examples rather than a combined beginner path through a function dialog and direct entry. | Compared with WPS: Google Sheets offers the same function, but it is centered on a browser-based spreadsheet workflow. | Compared with WPS: Notion formulas are designed for database properties rather than a traditional spreadsheet formula-entry workflow. | Compared with WPS: Adobe official materials here are for PDF JavaScript automation, not worksheet formula entry and fill-down use. |
| Official Source | — | TRUNC function | TRUNC | Formula syntax and functions | Acrobat JavaScript API Reference |
Overall Conclusion: If your main task is spreadsheet work on Windows and you need a clear way to enter and reuse a truncation formula, WPS Sheets provides a direct workflow for that. Other products fit different priorities, such as browser-based collaboration, database formulas, or PDF scripting.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Financial value truncation | Finance staff, cashiers | Need to keep fixed decimal places without rounding | Use TRUNC to cut off extra digits in amounts or rates |
| 2 | Report display cleanup | Operations staff, administrative staff | Need consistent decimal display in reports | Enter a TRUNC formula in the result column and fill it down |
| 3 | Formula learning | New users | Not familiar with parameter structure | Use the Insert Function dialog to review parameter guidance |
| 4 | Batch calculations | Data processing staff | Need the same truncation logic across many cells | Enter the formula once and fill it down |
| 5 | Negative number checks | Reviewers, analysts | Negative-number results can be confused with rounding or INT behavior | Review the syntax and compare results with different num_digits values |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| Enter and calculate with the TRUNC function | ✅ | ✅ |
| View parameter guidance through Insert Function | ✅ | ✅ |
| Other WPS premium services | Available within the free offering | Additional benefits depend on the selected subscription plan |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Everyday spreadsheet calculations and basic formula learning | Free | The TRUNC function itself does not require membership |
| Ongoing work that also needs broader premium services | WPS Premium | Suitable when you also need additional membership benefits across WPS Office |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page