SheetFX
≡
<< Go back to all functions

TRUNC

The TRUNC function in Google Sheets truncates a number to a certain number of significant digits by omitting less significant digits. Whether you need to round down a decimal value or remove unnecessary digits from a number, the TRUNC function simplifies the task. Explore our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: TRUNC(value, [places])

Parameters:

  • value: The number to be truncated.
  • places: [Optional] The number of decimal places to keep. If omitted, the value is truncated to the nearest integer.

Step-by-Step Tutorial

  1. Truncating a number without decimal places:

    • Example: =TRUNC(5.78)
    • Result: 5

  2. Truncating a number with decimal places:

    • Example: =TRUNC(9.876, 2)
    • Result: 9.87

Use Cases and Scenarios

  1. Financial Analysis: Truncate currency values to a certain number of decimal places.
  2. Scientific Calculations: Remove less significant digits from scientific measurements.
  3. Data Cleansing: Round down data values for consistent formatting.

Related Functions

  • ROUND: Round a number to a specified number of decimal places.
  • CEILING: Round a number up to the nearest integer or to the nearest multiple of significance.
  • FLOOR: Round a number down to the nearest integer or to the nearest multiple of significance.

Related Articles