ReferenceFunctionsMath Functions

DECIMAL

Converts text in a given radix back to a decimal number.

Summary

Converts text in a given radix back to a decimal number.

Examples

Convert hexadecimal to decimal

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

31

FAQ

Is DECIMAL case-sensitive for alphabetic digits?

No. Inputs like "ff" and "FF" both work for hexadecimal conversions.

Runtime metadata

Category

Math

Signature

DECIMAL(arg1: Any, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Any · Scalar

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

CSCH

CSCH: Returns the hyperbolic cosecant of a number, defined as `1 / SINH(x)`.

DEGREES

Converts an angle from radians to degrees.

On this page

Summary Examples Related functions FAQ Is DECIMAL case-sensitive for alphabetic digits?Runtime metadata