Formualizer Docs
ReferenceFunctionsMath Functions

ROMAN

Converts an Arabic number to a Roman numeral string.

Summary

Converts an Arabic number to a Roman numeral string.

Remarks

  • Accepts integer values in the range 0..=3999.
  • 0 returns an empty string.
  • Optional form controls output compactness (0 classic through 4 simplified).
  • Out-of-range values return #VALUE!.

Examples

Classic Roman numeral
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
MCMXCIX
Another conversion
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
XLIV

FAQ

What input range does ROMAN support?

ROMAN accepts truncated integers from 0 through 3999; outside that range it returns #VALUE!.

Runtime metadata

Category

Math

Signature

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

RADIANS

Converts an angle from degrees to radians.

ROUND

Rounds a number to a specified number of digits.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat input range does ROMAN support?Runtime metadata