Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Count rows with at least n matching values
  • How to reference named range different sheet in Excel
  • Basic INDEX MATCH approximate in Excel
  • How to use Excel MMULT Function

Data Analysis Examples

  • Everything about Charts in Excel
  • Get column index in Excel Table
  • Conditional Formatting Data bars Examples in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Example of COUNTIFS with variable table column in Excel

Data Validation Examples

  • Excel Data validation no punctuation
  • Prevent invalid data entering in specific cells
  • Excel Data validation only dates between
  • Excel Data validation specific characters only
  • Excel Data validation allow weekday only

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.

Post navigation

Previous Post:

Excel MROUND, CEILING and FLOOR function examples

Next Post:

Excel Frequency Function Example

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • UNICODE function: Description, Usage, Syntax, Examples and Explanation
  • How to extract substring in Excel
  • How to strip protocol and trailing slash from URL in Excel
  • Join first and last name — Manipulating NAMES in Excel
  • How to extract multiple lines from a cell in Excel
  • Get day name from date in Excel
  • Extract time from a date and time in Excel
  • How to get Weekdays, Working days between Two Dates in Excel
  • How to calculate most recent day of week in Excel
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • Example of payment for annuity in Excel
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
  • Calculate payment periods for loan in Excel
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles