Formualizer Docs
ReferenceFunctionsMath Functions

CEILING.MATH

Rounds a number up to the nearest integer or multiple using `CEILING.MATH` rules.

Summary

Rounds a number up to the nearest integer or multiple using CEILING.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 away from zero; otherwise it rounds toward positive infinity.

Examples

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

FAQ

How does mode affect negative numbers in CEILING.MATH?

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

Runtime metadata

Category

Math

Signature

CEILING.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

CEILING

CEILING: Rounds a number up to the nearest multiple of a significance.

COMBIN

Returns the number of combinations for selecting `k` items from `n`.

On this page

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