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
Excel 2016 Formulas and Functions (includes Content Update Program) by McFedries Paul.mobi
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.
Microsoft Access | Microsoft Excel |
Microsoft Office | Microsoft Outlook |
Microsoft Powerpoint | Microsoft Project |
Microsoft Sharepoint | Microsoft Windows |
Microsoft Word |
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(5933)
Linux Device Driver Development Cookbook by Rodolfo Giometti(3335)
Implementing Enterprise Observability for Success by Manisha Agrawal and Karun Krishnannair(2742)
TCP IP by Todd Lammle(2615)
Drawing Shortcuts: Developing Quick Drawing Skills Using Today's Technology by Leggitt Jim(2516)
Pandas Cookbook by Theodore Petrou(2488)
Applied Predictive Modeling by Max Kuhn & Kjell Johnson(2460)
Learn Qt 5: Build modern, responsive cross-platform desktop applications with Qt, C++, and QML by Nicholas Sherriff(2166)
40 Algorithms Every Programmer Should Know by Imran Ahmad(2099)
Design Made Easy with Inkscape by Christopher Rogers(2026)
Supercharging Productivity with Trello by Brittany Joiner(2011)
Fusion 360 for Makers by Lydia Sloan Cline(1977)
The Artificial Intelligence Imperative by Anastassia Lauterbach(1834)
Build Stunning Real-time VFX with Unreal Engine 5 by Hrishikesh Andurlekar(1816)
Mastering Tableau 2023 - Fourth Edition by Marleen Meier(1712)
The Old New Thing by Raymond Chen(1710)
Mastering Python Scientific Computing by Hemant Kumar Mehta(1702)
Customizing Microsoft Teams by Gopi Kondameda(1647)
Inkscape by Example by István Szép(1618)