Spread Silverlight Documentation
Spread Silverlight Documentation / Formula Reference / Formula Functions / INT
In This Topic
    INT
    In This Topic

    Summary

    This function rounds a specified number down to the nearest integer.

    Syntax

    INT(value)

    Arguments

    Use any numeric value for the argument.

    Remarks

    You can use this function to return the decimal portion of the value in a cell by subtracting the value of this function for the cell from the value in the cell, as illustrated in the first example.

    The TRUNC and INT functions are similar in that both 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) returns –4, but INT(–4.2) returns –5 because –5 is the lower number.

    Data Types

    Accepts numeric data. Returns numeric data.

    Examples

    INT(A3)

    R1C2-INT(R1C2)

    INT(2.85) gives the result 2

    INT(-2.85) gives the result -3

    See Also