Documentation/Calc Functions/INT

    From The Document Foundation Wiki
    Other languages:


    Function name:

    INT

    Category:

    Mathematical

    Summary:

    Rounds a number down to the nearest integer by determining the largest integer that is less than or equal to that number.

    Syntax:

    INT(Number)

    Returns:

    Returns an integer that is the mathematical floor value of the specified number.

    Arguments:

    Number is a real number, or a reference to the cell containing that number, that is the number to be rounded down to the nearest integer.

    • If Number is non-numeric, then INT reports a #VALUE! error.

    Additional details:

    None.

    Examples:

    Formula Description Returns
    =INT(5.7) Rounds down 5.7 to the nearest integer. 5
    =INT(D1) where cell D1 contains the number -1.3. Rounds down -1.3 to the nearest integer. −2

    Related LibreOffice functions:

    FLOOR

    FLOOR.MATH

    FLOOR.PRECISE

    FLOOR.XCL

    ROUND

    TRUNC

    ODF standard:

    Section 6.17.2, part 2

    Related (or similar) Excel functions:

    INT