INT

Returns the integer resulting from truncating a number.

Syntax

INT(Value)

Value is a number or a formula resulting in a number. If Value is positive, the result is the largest integer less than or equal to Value. If Value is negative, the result is the smallest integer greater than or equal to Value.

Examples

This example returns 7:

INT(7.8)

This example returns -7:

INT(-7.8)