Formualizer Docs
ReferenceFunctionsMath Functions

ABS

Returns the absolute value of a number.

Summary

Returns the absolute value of a number.

Remarks

  • Negative numbers are returned as positive values.
  • Zero and positive numbers are unchanged.
  • Errors are propagated.

Examples

Absolute value of a negative number
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
12.5
Absolute value from a cell reference
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
42

FAQ

How does ABS handle errors or non-numeric text?

Input errors propagate, and non-coercible text returns a coercion error.

Runtime metadata

Category

Math

Signature

ABS(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

Math Functions

Generated reference pages for Math functions.

ACOS

ACOS: Returns the angle in radians whose cosine is the input value.

On this page

SummaryRemarksExamplesRelated functionsFAQHow does ABS handle errors or non-numeric text?Runtime metadata