Excel: Roman Function

In Excel, the Roman function converts a number to roman numeral.

The syntax for the Roman function is:

Roman( number, type )

number is the number that you wish to convert to roman numeral.

type is optional. It is the type of roman numeral that you wish to convert to. type can be any of the following values:

Value Explanation

0 Classic (default).

1 More concise.

2 More concise.

3 More concise.

4 Simplified.

TRUE Classic.

FALSE Simplified.

If type is omitted, the Roman function will assume a type of 0.

Note:

If a negative number is entered as the number parameter, the Roman function will return the #VALUE! error.

If a number greater than 3999 is entered as the number parameter, the Roman function will return the #VALUE! error.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Roman(A1) would return XLIX

=Roman(A2) would return L

=Roman(A3) would return MMIV

=Roman(999, 0) would return CMXCIX

=Roman(999, 1) would return LMVLIV

=Roman(999, 2) would return XMIX

=Roman(999, 3) would return VMIV

=Roman(999, 4) would return IM