TRUNC Function or TRUNC Formula in Excel with example

TRUNC Function or TRUNC Formula in Excel with example

TRUNC

Function truncates a number to an integer by removing the decimal, or fractional part of the number. TRUNC Function ensures removal of decimal, number of places of decimal should be adjusted manually else TRUNC function will replace removed number with padded ZERO (0).

Syntax

=TRUNC(number, [num_digits])

  • number: a mandatory parameter, represents a valid number, expected with decimal.
  • num_digits: an optional parameter, if omitted, all decimal values would be removed or replaced with leading ZEROs, If specified, it removes those many decimals from input number.

Formula

Output

Next >> RANK Function in Excel with example

Leave a Reply

Your email address will not be published.