From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using the INT and TRUNC functions to extract integer data

Using the INT and TRUNC functions to extract integer data

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using the INT and TRUNC functions to extract integer data

“

- There are four kinds of rounding functions that you could be interested in. One is called TRUNC, think of the word truncate, another one, called INT, think of the word integer. Let's look at these two first of all. We've got some calculations in column C, just a simple formula, creating some new numbers. And we could have used, possibly, the TRUNC or the INT function, to simply throw away the pennies, if these were dollars and cents. The TRUNC function, used right here, simply says, let's not show anything to the right of the decimal, throw it away. And you can see what's happening in each of these cases here. The integer function does what looks like exactly the same thing. Here we see INT, and what is it doing? The same thing. The integer function, the INT function, always returns a lower value. So in each case here, this is lower than that. And for the moment, based on the list we're seeing, TRUNC does exactly the same thing. If you're working with positive numbers, TRUNC and INT…

Contents