Thursday, 20 April 2017

Excel - Microsoft Excel Trunc Function

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