MS 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