Navigation:  Formulas and functions > Functions from A to Z > ROMAN (Roman numeral)

Syntax:

ROMAN(Number [, Format])

Description:

This converts an Arabic numeral into a Roman numeral (as a text string).

Number must be ≥ 0 and < 4000.

Number should be an integer, as digits to the right of the decimal point are ignored.

If Number equals zero, an empty text string will be returned.

If the optional argument Format is used, Calculate tries to create a shorter form of the Roman numeral. Format can be any integer from 0 (do not shorten) to 4 (shorten as much as possible).

Example:

ROMAN(1999) returns MCMXCIX

ROMAN(1999, 0) also returns MCMXCIX

ROMAN(1999, 1) returns MLMIL

ROMAN(1999, 2) returns MXMIX

ROMAN(1999, 3) returns MVMIV

ROMAN(1999, 4) returns MIM