INT ROUND & TRUNC

[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). 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

 

[Bob Phillips]

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)

 

[joeu2004]

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.