INT

MS Excel Spreadsheet

See Also

Rounds a number down to the nearest integer.

Syntax

INT(number)

Number    is the real number you want to round down to an integer.

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

ShowHow?

Data
19.5
Formula Description (Result)
=INT(8.9) Rounds 8.9 down (8)
=INT(-8.9) Rounds -8.9 down (-9)
=A2-INT(A2) Returns the decimal part of a positive real number in cell A2 (0.5)