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
|