The Excel ROMAN function converts an arabic number to Roman. I.e. for a supplied integer, the function returns a text string depicting the roman numeral form of the number.
Syntax: =ROMAN (number, [form])
The ROMAN function syntax has the following arguments:
- Number Required. The Arabic numeral you want converted.
Form Optional. A number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases. If supplied, this must have one of the following values:
Value Explanation Classic (default) 1 More concise 2 More concise 3 More concise 4 Simplified TRUE Classic FALSE Simplified
If the [form] argument is omitted, it takes on the default value of 0 (denoting the classic form is used).
Example: Let’s look at some Excel ROMAN function examples and explore how to use the ROMAN function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following ROMAN examples would return:
- Number must be positive and less than the value 3999.
- The ROMAN function does the opposite of the ARABIC function
- The form argument controls whether the roman numeral is abbreviated or not. The argument is optional and the default is zero (classic non-abbreviated). The ROMAN function supports additional forms 1-4 which are progressively more concise.
- Note that if any of the arguments are input as decimal values, they are truncated to integers.
- #VALUE! – Occurs if either: The supplied number is < 0 or > 3999, or is non-numeric; or the supplied [form] argument is supplied but is invalid (i.e. is not one of the values 0, 1, 2, 3 4, TRUE or FALSE).
- Roman numerals are represented by combinations of letters
- I = 1
- V = 5
- X = 10
- L = 50
- C = 100
- D = 500
- M = 1000