INT

INT(number)

Returns the number rounded down to the nearest integer.

numberThe number you want to round down to an integer.

REMARKS
* Negative numbers are rounded down.
* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.
* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.
* You can use the MROUND function to round to a desired multiple.
* You can use the ROUND function to round to a specified number of digits.
* You can use the ROUNDOWN function to round down to a specified number of digits.
* You can use the ROUNDUP function to round up to a specified number of digits.
* You can use the TRUNC function to return a number with any decimal placed removed.
* The equivalent VBA function is VBA.INT
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=INT(1.5) = 1
2=INT(-4.3) = -5
3=INT(-8.9) = -9
4=INT(50.01) = 50
5=INT(50.99) = 50
6=INT(-50.01) = -51
7=INT(-50.99) = -51
8=INT("") = #VALUE!
9=INT("some text") = #VALUE!


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