Formualizer Docs
ReferenceFunctionsMath Functions

ROUNDUP

ROUNDUP: Rounds a number away from zero to a specified number of digits.

Summary

Rounds a number away from zero to a specified number of digits.

Remarks

  • Positive num_digits affects decimals; negative values affect digits left of the decimal.
  • Any discarded non-zero part increases the magnitude of the result.
  • Input errors are propagated.

Examples

Round up decimals away from zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3.142
Round up a negative value at the hundreds place
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-1000

FAQ

What does ROUNDUP do when discarded digits are already zero?

It leaves the value unchanged because no non-zero discarded part remains.

Runtime metadata

Category

Math

Signature

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

ROUNDDOWN

ROUNDDOWN: Rounds a number toward zero to a specified number of digits.

SEC

Returns the secant of an angle, defined as `1 / COS(angle)`.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat does ROUNDUP do when discarded digits are already zero?Runtime metadata