SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / TRUNC
In This Topic
    TRUNC
    In This Topic

    This function removes the specified fractional part of the specified number.

    Syntax

    TRUNC(value,precision)

    Arguments

    This function has these arguments:

    Argument Description
    value Number to truncate
    precision Integer representing the precision; if greater than zero, truncates to the specified number of decimal places; if zero (or not specified), truncate to the nearest whole number; if less than zero, rounds the value left of the decimal to the nearest order of tens

    Remarks

    The TRUNC and INT functions are similar in that both can return integers. Use the TRUNC function to remove the decimal portion of the number; the TRUNC function does not round up or down. Use the INT function to round numbers down to the nearest integer based decimal portion of the number.

    These functions differ also when using negative numbers: TRUNC(–4.2, 0) returns –4, but INT(–4.2) returns –5 because –5 is the lower number.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    TRUNC(B16)

    TRUNC(R16C2)

    TRUNC(5.745) gives the result 5

    TRUNC(-5.745) gives the result -5

    TRUNC(5.745,2) gives the result 5.74

    TRUNC(PI()) gives the result 3

    See Also