Formualizer Docs
ReferenceFunctionsMath Functions

MROUND

MROUND: Rounds a number to the nearest multiple.

Summary

Rounds a number to the nearest multiple.

Remarks

  • Returns 0 when multiple is 0.
  • If number and multiple have different signs, returns #NUM!.
  • Midpoints are rounded away from zero.

Examples

Round to nearest 5
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
15
Round negative value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-15

FAQ

Why does MROUND return #NUM! for mixed signs?

If number and multiple have different signs (excluding zero), MROUND returns #NUM!.

Runtime metadata

Category

Math

Signature

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

MOD

MOD: Returns the remainder after division, with the sign of the divisor.

MULTINOMIAL

Returns the multinomial coefficient for one or more values.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does MROUND return #NUM! for mixed signs?Runtime metadata