Options for entering the function include manually typing in the entire function =TRUNC(A4,2), or using the function’s dialog box – as outlined below: In these instances, the function removes all decimal values and, depending on the value of Num_digits, rounds the number down to that many digits. For example, when Num_digits is:
Equal to -1, the number is rounded down to the nearest value of 10. Shown in row seven.Equal to -10, the number is rounded down to the nearest value of 100. Shown in row eight.Equal to -100, the number is rounded down to the nearest value of 1,000. Shown in row nine.
The syntax for the TRUNC function is: = TRUNC (Number, Num_digits) Number - the value to be truncated. This argument can contain:
The actual data to be truncated. Shown in rows two and three above. The results of a formula. Shown in row three above, where TRUNC is used to shorten the value returned by the PI function. A cell reference to the location of the data in the worksheet. Shown in rows four to nine above. The reference can also point to a cell containing the value returned by a formula – the value in cell A4 is generated by the PI function.
Num_digits (Optional): The number of decimal places to be left by the function.
If Num_digits is omitted a default value of zero is used for this argument and all decimal places are removed and a non-rounded integer value is returned by the function. Shown in row five above.
There are, on the other hand, formatting options in Excel that allow you change the number of decimal places displayed by your data without changing the numbers themselves. Making formatting changes to data has no effect on calculations.
