INT

Rounds the specified number down to the nearest integer.

Syntax

INT( Number n ) → Number

Parameters

n

Required. The number to round.

Example

Formula

=INT(5.8)
=INT(-4.2)

See Also

Function Reference
CEILING Function
FLOOR Function
MOD Function
MROUND Function
ROUND Function
TRUNC Function