| Syntax |
| =INT(number) |
| Purpose / Description |
| It returns the highest whole number equal to or less than a value provided, converting the number to an integer. |
| Arguments |
| Name |
Type |
Description |
| number |
number |
A reference or nested expression that returns a valid reference, a constant or a nested expression that returns a numeric value to be returned as an integer. Normal coercion rules apply, so if a text string or a logical value is passed, they will be coerced to a number if possible. Will accept an array of values to round. |
| Return Values |
| Type |
Specific Value |
Description |
| number |
|
Returns the result(s) of the integer conversion. If an array of values is passed to the number argument, an array of the same dimensions is returned, containing the integer result for each value in the array. |
| error |
#VALUE! |
If the value of number is not a number and is not capable of coercion to a number. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Comment: |
The value returned is always equal to or less than the value passed to number. The absolute value of the results vary between positive and negative values for the number argument. For example =INT(2.9) returns 2, whereas =NT(-2.9) returns -3. For financial applications,the TRUNC function is generally preferable, as the absolute value of the results is the same. |
| Examples: |
Open / download sample workbook: INT TRUNC.xlsx |
| |