Use of INT and TRUNC function in Excel

by

This example illustrates two functions to chop off decimals in Excel. The INT and the TRUNC function.

Int

The INT (Integer) function rounds a number down to the nearest integer.

Worked Example:   INT function: Description, Usage, Syntax, Examples and Explanation

Conclusion: the INT function only chops off decimals from positive numbers.

Worked Example:   Get days, hours, and minutes between dates in Excel

Trunc

Truncate a number to a given precision. The TRUNC (Truncate) function always chops off decimals.

Worked Example:   Calculate years between dates in Excel

The TRUNC function can keep any number of decimals and chop off the rest.

Leave a Reply

Your email address will not be published. Required fields are marked *