Formualizer Docs
ReferenceFunctionsMath Functions

CEILING.PRECISE

CEILING.PRECISE: Rounds a number up toward positive infinity using absolute significance.

Summary

Rounds a number up toward positive infinity using absolute significance.

Examples

Round a negative number upward
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-4

FAQ

Does the sign of significance matter?

No. CEILING.PRECISE uses the absolute value of significance.

Runtime metadata

Category

Math

Signature

CEILING.PRECISE(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.MATH

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

COMBIN

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

On this page

SummaryExamplesRelated functionsFAQDoes the sign of significance matter?Runtime metadata