ReferenceFunctionsMath Functions

ARABIC

Converts a Roman numeral string to its Arabic numeric value.

Summary

Converts a Roman numeral string to its Arabic numeric value.

Remarks

Accepts text input containing Roman symbols (I,V,X,L,C,D,M).
Surrounding whitespace is trimmed.
Empty text returns 0.
Invalid Roman syntax returns #VALUE!.

Examples

Roman to Arabic

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1999

Trimmed input

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

44

FAQ

What causes ARABIC to return #VALUE!?

Invalid Roman symbols/syntax, non-text input, or overlength text produce #VALUE!.

Runtime metadata

Category

Math

Signature

ARABIC(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ACOT

ACOT: Returns the angle in radians whose cotangent is the input value.

ASIN

ASIN: Returns the angle in radians whose sine is the input value.

On this page

Summary Remarks Examples Related functions FAQ What causes ARABIC to return #VALUE!?Runtime metadata