TRUNC Function in Excel truncates the number to the specified decimal places. If nothing is specified then TRUNC function truncates the number to a integer(truncates the decimal places).
Syntax of TRUNC function in Excel
TRUNC(number,[num_digits])
number – The number to be truncated
num_digits – optional: The number of decimal places to which the number has to be truncated.
- A positive [num_digits] value specifies the number of digits to the right of the decimal point.
- If [num_digits] value of 0 specifies truncate to the nearest integer.
- A negative [num_digits] value specifies the number of digits to the left of the decimal point.
Example of TRUNC Function in Excel
FORMULA
- Row number 2 & 3 truncates to 1 and 2 decimal places respectively
- Row number 4 truncates to nearest integer
- Row number 5 truncates to 1 decimal place
- Row number 6 truncates to nearest 100
So the result will be