TRUNC in WPS on Windows FAQ

Last updated:July 20, 2026

When using the TRUNC function, common questions usually involve formula entry, parameter setup, unexpected results, and recalculation; this FAQ includes 4 common questions and a glossary.

FAQ

What should I do if the TRUNC function shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Check whether all parentheses are closed.
  3. Check whether the parameter count, order, and separators are correct.
  4. Review the syntax guidance and confirm the formula again.

How can I view help for the TRUNC function?

  1. Select any editable cell.
  2. Type =TRUNC(.
  3. Review the syntax guidance and parameter information that appears.
  4. Continue entering or editing the formula as needed.

Why is my TRUNC result not correct?

  1. Check whether the referenced cell contains a numeric value.
  2. Check whether the digit parameter matches your calculation need.
  3. Check whether other nested functions affect the result.
  4. Confirm the result again after making changes.

Why does the result not change after I edit the source data?

  1. Check whether the result cell still contains a formula instead of a fixed value.
  2. Check whether the reference points to the correct cell or worksheet.
  3. Check whether the source data was entered as text.
  4. Edit and confirm the formula again, then review the result.

Glossary

TermDefinition
TRUNCA function that truncates the decimal portion of a number and can keep a specified number of digits based on parameters.
Syntax guidanceThe parameter and format prompt shown while entering a function to help you complete the formula correctly.
Nested calculationA calculation method that uses another function or expression inside one formula.
Cross-sheet referenceA way to reference cell data from another worksheet in the current formula.