Microsoft Office Tutorials and References
In Depth Information
Using =ROMAN() to Finish Movie Credits and =ARABIC() to Convert Back to Digits
The ROMAN function converts an Arabic numeral to Roman, as text. The func-
tion works with the positive integers from 1 to 3999. This function takes the
number — This is the Arabic numeral you want converted.
form — This is a number that specifies the type of Roman numeral you
want. The Roman numeral style ranges from Classic to Simplified, be-
coming more concise as the value of formincreases.
There are some arcane rules with Roman numerals. In classic Roman numbers,
an I before a V is used to indicate the number 4. In classic Roman numbers, it is
valid to use an I before a V or an X, but it is not valid to use an I before an L,
a C, a D, or an M.
As shown in Figure 11.23 , the form argument allows Excel to bend these rules
• ROMAN(1999,0) results in MCMXCIX. The M is 1000, the CM is 900, the
XC is 90, and the IX is 9; 1000 + 900 + 90 + 9 = 1999.
• ROMAN(1999,1) results in MLMVLIV. The M is 1000, the LM is 950, the
VL is 45, and the IV is 4; 1000 + 950 + 45 + 4 = 1999.
• ROMAN(1999,2) results in MXMIX. The M is 1000, the XM is 990, and
the IX is 9; 1000 + 990 + 9 = 1999.
• ROMAN(1999,3) results in MVMIV. The M is 1000, the VM is 995, and the
IV is 4; 1000 + 995 + 4 = 1999.
• ROMAN(1999,4) results in MIM. The M is 1000 and the IM is 999; 1000 +
999 = 1999.