ReferenceFunctionsMath Functions

FLOOR.PRECISE

FLOOR.PRECISE: Rounds a number down toward negative infinity using absolute significance.

Summary

Rounds a number down toward negative infinity using absolute significance.

Examples

Round a negative number downward

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

-5

FAQ

Does FLOOR.PRECISE keep negative significance?

No. Like Excel, this implementation uses the absolute value of significance.

Runtime metadata

Category

Math

Signature

FLOOR.PRECISE(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

FLOOR.MATH

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

GCD

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

On this page

Summary Examples Related functions FAQ Does FLOOR.PRECISE keep negative significance?Runtime metadata