# INT

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function rounds a specified number down to the nearest integer.

## Syntax

INT(*value*)

## Arguments

Use any numeric value for the argument.

## Remarks

You can use this function to return the decimal portion of the value in a cell by subtracting the value of this function for the cell from the value in the cell, as illustrated in the first example.
The [TRUNC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionTRUNC) and INT functions are similar in that both return integers. Use the TRUNC function to remove the decimal portion of the number; the TRUNC function does not round up or down. Use the INT function to round numbers down to the nearest integer-based decimal portion of the number.These functions differ also when using negative numbers: TRUNC(–4.2) returns –4, but INT(–4.2) returns –5 because –5 is the lower number.

## Data Types

Accepts numeric data. Returns numeric data.

## Examples

`INT(A3)`
`R1C2-INT(R1C2)`
`INT(2.85)` gives the result 2
`INT(-2.85)` gives the result -3

## Version Available

This function is available in product version 1.0 or later.

## See Also

[CEILING](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionCEILING) \| [EVEN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionEVEN) \| [FLOOR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionFLOOR) \| [TRUNC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionTRUNC) \| [Math and Trigonometry Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsmathtrig)