Chop off Decimals in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/chop-off-decimals.
html
Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us
Chop off Decimals
Int | Trunc
Chapter
This example illustrates two functions to chop off decimals in Excel. The INT and the TRUNC function.
Round
Int
The INT (Integer) function rounds a number down to the nearest integer.
Learn more, it's easy
Chop off Decimals
Nearest Multiple
Even and Odd
Download Excel File
chop-off-decimals.xls
Follow Excel Easy
1 of 4 08-11 06:15 PM
Chop off Decimals in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/chop-off-decimals.html
Conclusion: the INT function only chops off decimals from positive numbers.
Trunc
The TRUNC (Truncate) function always chops off decimals.
The TRUNC function can keep any number of decimals and chop off the rest.
2 of 4 08-11 06:15 PM
Chop off Decimals in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/chop-off-decimals.html
DHFL Home Loan
Home loan @ 9.55%*. Pay Lower EMI. Loan of upto 30 years. Apply Now!
Start Download
Gain money, the smart way
Jaguar XF @Rs.48.51 Lacs*
ROHM Power MOSFETs
7 days free trial
HDFC™ Home Loans @9.50...
Start Download
Download Application Form
Salary & Payroll Software
Do you like this free website? Please follow us on Google+
Learn more about rounding, use the side menu >>
Go to Top: Chop off Decimals | Go to Next Chapter: Formula Errors
3 of 4 08-11 06:15 PM
Chop off Decimals in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/chop-off-decimals.html
COPYRIGHT (C) 2010-2015 WWW.EXCEL-EASY.COM. ALL RIGHTS RESERVED.
EXCEL 2010 TUTORIAL | HOW TO EXCEL | MICROSOFT EXCEL 2010 | EXCEL MACRO
4 of 4 08-11 06:15 PM
