ReferenceFunctionsMath Functions

INT

Rounds a number down to the nearest integer.

Summary

INT uses floor semantics, so negative values move farther from zero.

Remarks

Equivalent to mathematical floor (floor(x)).
Coercion is lenient for numeric-like inputs; invalid values return an error.
Input errors are propagated.

Examples

Drop decimal digits from a positive number

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

8

Floor a negative number

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

-9

FAQ

Why is INT(-8.9) equal to -9 instead of -8?

INT uses floor semantics, so negative values round toward negative infinity.

Runtime metadata

Category

Math

Signature

INT(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

GCD

GCD: Returns the greatest common divisor of one or more integers.

LCM

LCM: Returns the least common multiple of one or more integers.

On this page

Summary Remarks Examples Related functions FAQ Why is INT(-8.9) equal to -9 instead of -8?Runtime metadata