
ROMAN
The ROMAN function converts a number to Roman numerals.
ROMAN(arabic-num, roman-style)
arabic-num: The Arabic numeral that you want to convert. arabic-num is a number value in the range 0 to 3999.
roman-style: An optional modal value that determines how strictly the classical rules for forming Roman numerals are applied.
strict (0 or TRUE, or omitted): Use the most strict classical rules. When a smaller numeral precedes a larger to indicate subtraction, the smaller must be a power of 10 and can precede a number no more than 10 times its size. For example, 999 is represented as CMXCIX, but not LMVLIV.
relax by one degree (1): Relax the strict classical rule by one degree. When a smaller number precedes a larger, the smaller need not be a power of 10 and the relative size rule is extended by one numeral. For example, 999 can be represented as LMVLIV, but not XMIX.
relax by two degrees (2): Relax the classical rule by two degrees. When a smaller number precedes a larger, the relative size rule is extended by two numerals. For example, 999 can be represented as XMIX, but not VMIV.
relax by three degrees (3): Relax the classical rule by three degrees. When a smaller number precedes a larger, the relative size rule is extended by three numerals. For example, 999 can be represented as VMIV, but not IM.
relax by four degrees (4 or FALSE): Relax the classical rule by four degrees. When a smaller number precedes a larger, the relative size rule is extended by four numerals. For example, 999 can be represented as IM.
Examples |
---|
=ROMAN(12) returns XII. =ROMAN(999) returns CMXCIX. =ROMAN(999, 1) returns LMVLIV. =ROMAN(999, 2) returns XMIX. =ROMAN(999, 3) returns VMIV. |