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:   Convert inches to feet and inches in Excel

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

Worked Example:   Calculate years between dates in Excel

Trunc

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

Worked Example:   Cash denomination calculator 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.