INT(number)

Returns the number rounded down to the nearest integer (Double).


numberThe number you want to round down to an integer (Double)

REMARKS
* This function is identical to FIX function for positive numbers.
* The difference between this and the FIX function is that negative numbers are rounded down.
* This function truncates without rounding.
* This function always returns a Double.
* The value returned has the same data type as the value passed in.
* The fractional part of any number is removed and return the resulting integer value.
* If "number" < 0, then the first negative integer less than or equal to "number" is returned.
* You can use the ROUND function to return a number rounded to a given number of decimal places.
* The equivalent .NET function is Microsoft.VisualBasic.Conversion.Int
* For the Microsoft documentation refer to docs.microsoft.com

Int(-8.9) = -9 
Int(-8.4) = -9
Int(-8.1) = -9
Int(-7.9) = -8
Int(-1.9) = -2
Int(-1.1) = -2
Int(-0.1) = -1
Int(0.2) = 0
Int(0.5) = 0
Int(0.6) = 0
Int(0.9) = 0
Int(1.1) = 1
Int(1.5) = 1
Int(12.01) = 12
Int(12.34) = 12
Int(12.99) = 12

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