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

following arguments:

•
number

number
—
This is the Arabic numeral you want converted.

•
form

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

progressively more:

•
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.