The Excel ROMAN Function

Basic Description

The Excel ROMAN function converts an arabic number to Roman - i.e. for a supplied number, the function returns a text string depicting the roman numeral form of the number.

The format of the function is :

ROMAN( number, [form] )

Where the arguments are as follows :

number - The number that is to be converted to a Roman numeral (must be an integer between 0 and 1999)
[form] -

An optional argument that specifies the form of the Roman numeral returned

This can take any of the following values:
0 - Classic form
1 - More Concise
2 - More Concise
3 - More Concise
4 - Simplified form
TRUE - Classic form
FALSE - Simplified form
If the [form] argument is omitted, it takes on the default value of 0 (denoting the classic form is used).

Note that if any of the arguments are input as decimal values, they will be truncated to integers.


Roman Function Examples

The following spreadsheet shows example of the Excel Roman function used to convert the number 9999 to different forms of Roman numerals. The spreadsheet on the left shows the format of the function, and the spreadsheet on the right shows the result.

 Formulas:
Examples of use of the Excel Roman Function
 Results:
Excel Roman Function Results

Further examples of the Excel Roman function can be viewed on the Microsoft Office website.


Roman Function Error

If you get an error from the Excel Roman function this is likely to be the following :

Common Error
#VALUE! - Occurs if either :
- The supplied number is < 0 or > 3999, or is not recognised as a number
or
- The supplied [form] argument is supplied and is not recognised as either 0, 1, 2, 3 4, TRUE or FALSE
Return to the Excel Math Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net