Formualizer Docs
ReferenceFunctionsMath Functions

ISO.CEILING

ISO.CEILING: Rounds a number up using ISO ceiling semantics.

Summary

Rounds a number up using ISO ceiling semantics.

Examples

ISO ceiling on a negative value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-4

FAQ

How does ISO.CEILING differ from legacy CEILING?

ISO.CEILING always uses a positive significance and rounds toward positive infinity.

Runtime metadata

Category

Math

Signature

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

INT

Rounds a number down to the nearest integer.

LCM

LCM: Returns the least common multiple of one or more integers.

On this page

SummaryExamplesRelated functionsFAQHow does ISO.CEILING differ from legacy CEILING?Runtime metadata