INT

INT(number)

Returns the number rounded down to the nearest integer.

numberThe number you want to round down to an integer.

REMARKS
* Positive decimal numbers are rounded down.
* Negative decimal numbers are rounded down.
* If "number" is not numeric, then #VALUE! is returned.
* For positive numbers this is equivalent to the ROUNDDOWN function with "num_digits" set to 0.
* You can use the CEILING.MATH function to round up to the nearest integer or multiple.
* You can use the FLOOR.MATH function to round down to the nearest integer or 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 ROUND function to round to a certain number of decimal places or digits.
* You can use the ROUNDDOWN function to round down to a certain number of decimal places or digits.
* You can use the ROUNDUP function to round up 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.

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top