Description
The Excel Trunc function truncates a supplied number, to a specified number of decimal places.
The syntax of the function is:
TRUNC( number, [num_digits] )
Where the arguments are listed in the table below:
Trunc Function Examples
The following spreadsheet shows the Excel Trunc function used with different argument values:
The example in cell B3 of the above spreadsheet shows that, when the [num_digits] argument is omitted, it takes the default of 0. i.e. the supplied number is truncated to an integer.
No comments:
Post a Comment