How to Use the TRUNC Function in WPS on Windows

Last updated:July 20, 2026

Use the TRUNC function with 4 how-to topics, including 4 free topics and 0 membership-related topics; use the How-to Index to jump to the task you need.

How-to Index

No.TopicMembership Requirement
11. Enter the TRUNC functionFree
22. View syntax guidance and fill in parametersFree
33. Use TRUNC in a nested formulaFree
44. Check automatic recalculationFree

How-to Guide

1. Enter the TRUNC function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want to enter the formula.
  2. Type = in the formula bar or directly in the cell.
  3. Continue by typing TRUNC(.
  4. Get ready to enter the function parameters.

Success Criteria

  • Interface result: The cell enters formula editing mode.
  • What you can do next: You can continue entering parameters and complete the formula.

Tips While Using

  • Common mistake: If you do not type = first, the content may be treated as plain text.

2. View syntax guidance and fill in parameters

Entry point: Selected cell → formula bar

  1. After typing TRUNC(, check the syntax guidance that appears.
  2. Enter the number or cell reference to truncate.
  3. Add the digit parameter if needed.
  4. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell shows the calculation result.
  • What you can do next: When you select the cell again, you can review the full formula in the formula bar.

Tips While Using

  • Common mistake: An unclosed parenthesis or incorrect parameter separation can cause a formula error.

3. Use TRUNC in a nested formula

Entry point: Formula bar

  1. Select the target cell.
  2. Enter a combined formula that includes TRUNC.
  3. Add other functions or references to other sheets as needed.
  4. Press Enter to complete the calculation.

Success Criteria

  • Interface result: The cell returns the result of the combined formula.
  • What you can do next: The result can be referenced by other cells.

Tips While Using

  • Common mistake: If the formula has multiple nested levels, review parenthesis matching in the formula bar.

4. Check automatic recalculation

Entry point: Worksheet with a completed formula

  1. Find the source cell referenced by the TRUNC formula.
  2. Change the source data.
  3. Check whether the result cell updates at the same time.
  4. If needed, select the result cell again to review the formula.

Success Criteria

  • Interface result: The result updates when the referenced data changes.
  • What you can do next: You can continue saving, copying, or filling the formula into other cells.

Tips While Using

  • Common mistake: If the referenced value is stored as text, the result may not match expectations. Check the data type first.