Formualizer Docs
ReferenceFunctionsMath Functions

CEILING

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

Summary

This implementation defaults significance to 1 and normalizes negative significance to positive.

Remarks

  • If significance is omitted, 1 is used.
  • significance = 0 returns #DIV/0!.
  • Negative significance is treated as its absolute value in this fallback behavior.

Examples

Round up to the nearest multiple
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
6
Round a negative number toward positive infinity
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-4

FAQ

What happens if CEILING significance is 0?

It returns #DIV/0! because a zero multiple is invalid.

Runtime metadata

Category

Math

Signature

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

AVERAGEIFS

AVERAGEIFS: Returns the average of cells that satisfy multiple criteria.

CEILING.MATH

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhat happens if CEILING significance is 0?Runtime metadata