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.