# INT

### Definition of INT

Rounds a number down to the nearest integer that is less than or equal to it.

### Sample Usage

`INT(99.44)`

`INT(A2)`

### Syntax

`INT(value)`

`value`

- The value to round down to the nearest integer..

### Notes

`INT`

is*not*equivalent to`ROUNDDOWN`

with`count`

set to`0`

.`INT`

rounds down using value, whereas`ROUNDDOWN`

rounds down using absolute value, which causes differences for negative values of`value`

.`INT`

is also*not*equivalent to`FLOOR`

with significance`-1`

for negative values of`value`

for the same reason as above. It is, however, equivalent to`FLOOR`

with significance`1`

for positive values of`value`

and`CEILING`

with significance`-1`

for negative values of`value`

.

### See Also

`TRUNC`

: Truncates a number to a certain number of significant digits by omitting less significant digits.

`ROUNDUP`

: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

`ROUNDDOWN`

: Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

`ROUND`

: Rounds a number to a certain number of decimal places according to standard rules.

`MROUND`

: Rounds one number to the nearest integer multiple of another.

`FLOOR`

: Rounds a number down to the nearest integer multiple of specified significance.

`CEILING`

: Rounds a number up to the nearest integer multiple of specified significance.

### In order to use the INT formula, start with your edited Excellentable

### Then type in the INT Formula in the area you would like to display the outcome:

### Type in the complete INT formula for a cell as shown below:

### Excellentable will generate the outcome when hitting enter.