Formualizer Docs
ReferenceFunctionsMath Functions

ROUND

Rounds a number to a specified number of digits.

Summary

Rounds a number to a specified number of digits.

Remarks

  • Positive digits rounds to the right of the decimal point.
  • Negative digits rounds to the left of the decimal point.
  • Uses standard half-up style rounding from Rust's round behavior.

Examples

Round to two decimals
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3.14
Round to nearest hundred
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1200

FAQ

What does a negative digits argument do in ROUND?

It rounds digits to the left of the decimal point (for example, tens or hundreds).

Runtime metadata

Category

Math

Signature

ROUND(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

ROMAN

Converts an Arabic number to a Roman numeral string.

ROUNDDOWN

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhat does a negative digits argument do in ROUND?Runtime metadata