 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006INT ROUND & TRUNC
As far as I understand TRUNC will truncate a figure to either the integer or a specified number of decimal places. This can also be done by INT and ROUND (respectively). It is possible that TRUNC is provided as a duplicate method but it may do something different - or in a different way. I should appreciate some guidance on this - even if it is a link. Thanks. Bill Ridgeway INT and TRUNC differ in how they handles negative numbers. For instance, =TRUNC(-5.3) gives -5, whereas =INT(-5.3) gives -6. ROUND(num,0) works the same as INT, but rember that ROUND can work to a different number of digits, so it can be to 1, 2, 3, ... decimal places, or to -1, -2, -3, ... to powers of 10. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) > As far as I understand TRUNC will truncate a figure to either the integer or > a specified number of decimal places. This can also be done by INT and [quoted text clipped - 5 lines] > > Bill Ridgeway > As far as I understand TRUNC will truncate a figure to either the integer or > a specified number of decimal places. This can also be done by INT and > ROUND (respectively). While it is true that TRUNC and INT are similar insofar as they both truncate (drops the fractional part), ROUND is different insofar as it, well, rounds(!). For example, TRUNC(2.5) and INT(2.5) both yield 2, whereas ROUND(2.5,0) yields 3. > It is possible that TRUNC is provided as a duplicate > method but it may do something different - or in a different way. I should > appreciate some guidance on this - even if it is a link. Read the Excel Help pages. On the toolbar, click Help > Excel Help. (Note: I disable Online Content.) There is a difference between TRUNC and INT in the handling of negative numbers. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.