Formualizer Docs
ReferenceFunctionsMath Functions

FLOOR.MATH

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

Summary

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

Remarks

  • If significance is omitted (or passed as 0), the function uses 1.
  • significance is treated as a positive magnitude.
  • For negative numbers, non-zero mode rounds toward zero; otherwise it rounds away from zero.

Examples

Default behavior for a positive number
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
20
Use mode to round a negative number toward zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-20

FAQ

How does mode affect negative numbers in FLOOR.MATH?

With non-zero mode, negatives round toward zero; otherwise they round away from zero.

Runtime metadata

Category

Math

Signature

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

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

GCD

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

On this page

SummaryRemarksExamplesRelated functionsFAQHow does mode affect negative numbers in FLOOR.MATH?Runtime metadata