Trunc()

Working with Formulas > Functions Used in Formulas > Numeric Functions > Trunc()

TRUNC() returns a number that is truncated to the specified precision. If no precision is specified, TRUNC() returns the integer portion of the input number.

Function Format

TRUNC(number [, precision]) 

Return Value

TRUNC() returns a numeric value 

Examples

TRUNC(10.333) = 10 

TRUNC(10.333, 2) = 10.330 

TRUNC(10.666) = 10 

TRUNC(10.666, 2) = 10.660 

TRUNC(-10.333) = -10 

TRUNC(-10.666) = -10