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

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know