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:   TRUNC function: Description, Usage, Syntax, Examples and Explanation

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

Worked Example:   Excel Data validation whole percentage only

Trunc

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

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

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 *