Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
INT 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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
INT ROUND & TRUNC
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) "Bill Ridgeway" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
INT ROUND & TRUNC
Bill Ridgeway wrote:
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round time maybe this explanation will help | Excel Discussion (Misc queries) | |||
ROUND or "Precision as displayed"? | Excel Worksheet Functions | |||
round up a function RESULT | Excel Discussion (Misc queries) | |||
Round whole numbers up and down | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |