Int

Syntax

Int(Value)

Parameters

Value. The real number rounded down to the nearest integer.

NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.

Description

It returns the result of rounding the value to the nearest least integer.

Example

Formula Result Description
=Int(9.7) 9 It rounds the 9.7 number to the nearest least integer.
=Int(B6) -7 It rounds the number from the B6 cell to the nearest least integer. The B6 cell contains the -6.1 number.

See also:

Function Wizard │ Mathematical Functions │ Ceiling │ Even │ Floor │ MRound │ Odd │ Round │ RoundDown │ RoundUp │ Trunc