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:   Get days, hours, and minutes between dates in Excel

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

Worked Example:   Cash denomination calculator in Excel

Trunc

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

Worked Example:   Extract date from a date and time 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 *