Use the INT and TRUNC functions to extract integer data

- [Voiceover] Another variation on the concept of rounding,…is the idea that sometimes you don't want to keep…the decimal part of a number, or form a calculation.…In this worksheet called trunc int odd even,…we're talking about four different functions:…one called trunc, think of the word truncate;…another one called int, think of the word integer;…We've got some calculations in column B.…Now these could be pure numbers,…or in this case they're formulas.…The trunc function simply does what?…It simply keeps the decimal portion of this,…and we see what's happening here.…

It makes perfect sense when described that way.…In the int function over here, meaning integer,…in other words just give me…the whole number portion of this.…Skip the decimals, does the same thing.…Notice that we're not doing any rounding here.…At number 365.84 is certainly closer to 366,…but trunc says ignore the decimals, and so does int.…And we see how these could be used interchangeably here.…But farther down the list we've got some negative numbers.…