TRUNC Function in Excel – Truncate Values in Excel

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

TRUNC FUNCTION IN EXCEL 1

  • 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

Result

TRUNC FUNCTION IN EXCEL 2

previous-small TRUNC Function in Excel                                                                                                                next_small TRUNC Function in Excel