Math and Trignometric - TRUNC Function

Description

The TRUNC function truncates a number to an integer by removing the fractional part of the number.

Syntax

TRUNC (number, [num_digits])

Arguments

Argument Description Required/Optional
Number The number you want to truncate. Required
Num_digits A number specifying the precision of the truncation. The default value for num_digits is 0 (zero). Optional

Notes

  • TRUNC and INT are similar in that both return integers

    • TRUNC removes the fractional part of the number

    • INT rounds numbers down to the nearest integer based on the value of the fractional part of the number

  • INT and TRUNC are different only when using negative numbers.

  • For example, TRUNC (-4.3) returns -4, but INT (-4.3) returns -5 because -5 is the lower number

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

TRUNC Function
advanced_excel_math_trigonometric_functions.htm
Advertisements