Formualizer Docs
ReferenceFunctionsMath Functions

ROUNDDOWN

ROUNDDOWN: Rounds a number toward zero to a specified number of digits.

Summary

Rounds a number toward zero to a specified number of digits.

Remarks

  • Positive num_digits affects decimals; negative values affect digits left of the decimal.
  • Always reduces magnitude toward zero (unlike INT for negatives).
  • Input errors are propagated.

Examples

Trim decimals without rounding up
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3.141
Round down a negative value at the hundreds place
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-900

FAQ

Does ROUNDDOWN always move toward negative infinity?

No. It moves toward zero, which is different from FLOOR-style behavior on negatives.

Runtime metadata

Category

Math

Signature

ROUNDDOWN(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

ROUND

Rounds a number to a specified number of digits.

ROUNDUP

ROUNDUP: Rounds a number away from zero to a specified number of digits.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes ROUNDDOWN always move toward negative infinity?Runtime metadata