INT

Excel Functions

Get the integer part of a number by rounding down

Syntax

EXCEL

=INT(number)

Arguments

Parameter	Description
`number`	The number from which you want an integer.

Return Value

The integer part of the number after rounding down

Details

The INT function returns the integer part of a decimal number by rounding down to the integer. It is important to understand that the INT function returns the integer part of a decimal number, after rounding down. One consequence of this behavior is that negative numbers become more negative. For example, while INT(10.8) returns 10, INT(-10.8) returns -11. To return an integer by truncating decimals, see the TRUNC function. The INT function takes just one argument, number, which should be a numeric value. INT returns a #VALUE! error if number is not a numeric value. If number is already a whole number, INT has no effect. When numbers are positive, the INT function rounds down to the next lowest whole number: Notice INT rounds positive numbers down toward zero. With negative numbers, INT ro

Examples

When numbers are positive, the INT function rounds down to the next lowest whole number:

EXCEL

=INT(3.25) // returns 3
=INT(3.99) // returns 3
=INT(3.01) // returns 3

Examples

Notice INT rounds positive numbers down toward zero. With negative numbers, INT rounds down away from zero:

EXCEL

=INT(-3.25) // returns -4
=INT(-3.99) // returns -4
=INT(-3.01) // returns -4

INT

Syntax

Arguments

Return Value

Details

Examples

See Also