Excel 2016 Formulas and Functions (includes Content Update Program) by McFedries Paul

Author:McFedries, Paul
Language: eng
Format: epub, mobi
Publisher: Pearson Education
Published: 2015-09-24T16:00:00+00:00

The INT() and TRUNC() Functions

The INT() and TRUNC() functions are similar in that you can use both of them to convert a value to its integer portion:

INT(number)

TRUNC(number[, num_digits])

For example, INT(6.75) returns 6, and TRUNC(3.6) returns 3. However, these functions have two major differences that you should keep in mind:

For negative values, INT() returns the next number away from 0. For example, INT(-3.42) returns -4. If you just want to lop off the decimal part, you need to use TRUNC() instead.

You can use the TRUNC() function’s second argument (num_digits) to specify the number of decimal places to leave on. For example, TRUNC(123.456, 2) returns 123.45, and TRUNC(123.456, -2) returns 100.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.