Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Use of INT and TRUNC function in Excel

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


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

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


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

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

Also See:   INT function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply

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