INT

INT(number)

Returns the number rounded down to the nearest integer.

number

The number you want to round down to an integer.

REMARKS

* For an illustrated example refer to the Rounding Functions page.
* Positive decimal numbers are rounded down.
* Negative decimal numbers are rounded down.
* If "number" is not numeric, then #VALUE! is returned.
* You can use the CEILING.MATH function to round up by default to a certain multiple.
* You can use the EVEN function to return the number rounded to the nearest even integer.
* You can use the FLOOR.MATH function to round down by default to a certain multiple.
* You can use the MOD function to return the decimal part of a number.
* You can use the MROUND function to round to a certain multiple.
* You can use the ODD function to return the number rounded to the nearest odd integer.
* You can use the ROUND function to round to a certain number of decimal places or digits.
* You can use the ROUNDDOWN function to round towards zero to a certain number of decimal places or digits.
* You can use the ROUNDUP function to round away from zero to a certain number of decimal places or digits.
* You can use the TRUNC function to return a number with any decimal places removed.
* The equivalent VBA function is VBA.INT
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=INT(1.1) = 1
2	=INT(1.5) = 1
3	=INT(1.9) = 1
4	=INT(-1.1) = -2
5	=INT(-1.5) = -2
6	=INT(-1.9) = -2
7	=INT(123.456) = 123
8	=INT(123.567) = 123
9	=INT(-123.456) = -124
10	=INT(-123.567) = -124
11	=INT("") = #VALUE!
12	=INT("some text") = #VALUE!

1 - What is the number 1.1 rounded down to the nearest integer.
2 - What is the number 1.5 rounded down to the nearest integer.
3 - What is the number 1.9 rounded down to the nearest integer.
4 - What is the number -1.1 rounded down to the nearest integer.
5 - What is the number -1.5 rounded down to the nearest integer.
6 - What is the number -1.9 rounded down to the nearest integer.
7 - What is the number 123.456 rounded down to the nearest integer.
8 - What is the number 123.567 rounded down to the nearest integer.
9 - What is the number -123.456 rounded down to the nearest integer.
10 - What is the number -123.567 rounded down to the nearest integer.