ReferenceFunctionsMath Functions

FLOOR

FLOOR: Rounds a number down to the nearest multiple of a significance.

Summary

This implementation defaults significance to 1 and normalizes negative significance to positive.

Remarks

If significance is omitted, 1 is used.
significance = 0 returns #DIV/0!.
Negative significance is treated as its absolute value in this fallback behavior.

Examples

Round down to the nearest multiple

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

4

Round a negative number to a lower multiple

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

-6

FAQ

Why does FLOOR move negative values farther from zero?

FLOOR rounds down to a lower multiple, which is more negative for negative inputs.

Runtime metadata

Category

Math

Signature

FLOOR(arg1: Number, arg2…: Number)

Arity

min 1, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

FACT

Returns the factorial of a non-negative integer.

FLOOR.MATH

Rounds a number down to the nearest integer or multiple using `FLOOR.MATH` rules.

On this page

Summary Remarks Examples Related functions FAQ Why does FLOOR move negative values farther from zero?Runtime metadata