TRUNC

See also A-Z Spreadsheet Function List

Description Truncates the given number to an integer.

Syntax TRUNC(number [, precision])

number is any value.

precision is the number of decimal places allowed in the truncated number. Omitting this argument assumes a precision of 0.

Remarks TRUNC removes the fractional part of a number to the specified precision without rounding the number.

See Also CEILING , FLOOR , INT , MOD , and ROUND functions

Examples TRUNC(123.456, 2) returns 123.45

         TRUNC(9899.435, -2) returns 9800