Formulas and Functions

Related Topics
For related functions and additional information, see:
“RAND” on page 189
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
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 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.
19 0 Chapter 8 Numeric Functions