Use the INT function to return the lowest whole number portion of a formula or reference. When used with a negative number - =INT(-234.56) - the result is 235. INT always returns a value equal to or lower than the reference. Use the TRUNC function to return the whole number portion of a formula or reference.
- [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.…
Author
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel for Mac 2016: Pivot Tables in Depth
with Curt Frye2h 3m Intermediate -
Excel for Mac 2016: Charts in Depth
with Dennis Taylor4h 22m Intermediate
-
Introduction
-
Welcome46s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Use the INT and TRUNC functions to extract integer data