TRUNC Function in Google Sheets: Examples, Pitfalls & Compatibility
TRUNC in Google Sheets: discard digits toward zero at a selected decimal position without rounding up. Includes worked examples and application-specific cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Google Sheets. How formula examples are checked
Quick answer: Use TRUNC in Google Sheets to discard digits toward zero at a selected decimal position without rounding up. The official TRUNC reference is the source for the function definition and platform-specific rules described below.
Syntax and arguments
=TRUNC(value, [places])
value (required): The numeric input to truncate.
places (optional): Decimal position to retain; the default is 0. Positive positions are to the right of the decimal point; negative positions are to its left.
Square brackets mark optional arguments; do not type those brackets into the example formulas. Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.
When to use it
Use TRUNC when the written rule calls for discarding lower-order digits, not rounding to the nearest value. The default produces an integer toward zero, so it differs from INT on negative nonintegers.
Three worked examples
Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Google Sheets.
Example 1: Keep one decimal place
=TRUNC(18.765,1)
Expected result: 18.7.
Everything after the first decimal place is discarded.
Example 2: Check the same rule on a negative
=TRUNC(-18.765,1)
Expected result: -18.7.
The discarded tail does not make the negative result more negative.
Example 3: Keep the thousands position
=TRUNC(9876,-3)
Expected result: 9000.
The hundreds, tens and units are removed. This is truncation, not rounding 9876 up to 10000.
Put it to work safely
Record the permitted decimal position beside the raw numeric value and compute a separate truncated result. Review both positive and negative records before replacing source values. A number format may display two decimals without applying the same value transformation; choose whether the task is presentation or an actual change to the value used by later formulas.
Common mistakes and fixes
A final digit does not round up. TRUNC discards the remaining digits. Use ROUND when the nearest value is required.
Negative values disagree with INT. TRUNC moves toward zero while INT floors. Neither is universally more correct; use the rule required by the calculation.
Negative places are misunderstood. A negative position removes low-order whole-number digits. It does not mean “retain a negative number of decimals” in the display.
Google Sheets-specific notes
Google calls the optional argument places and documents negative positions as digits to the left of the decimal point. Think in decimal positions rather than a general count of significant figures. See the vendor reference for the current definition.
Excel and Google Sheets comparison
The demonstrated toward-zero behavior and decimal-place selection have the same intended meaning in both references. Independently checked decimal examples do not establish bit-for-bit agreement near every floating-point boundary.
Compare the TRUNC guide for Microsoft Excel and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.
Related guides
Evidence and testing scope
Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Google Sheets calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.