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:
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).|
Note that if any of the arguments are input as decimal values, they are truncated to integers.
The spreadsheets below show examples of the Excel Roman function used to convert the number 1999 to different forms of Roman numerals.
Further examples of the Excel Roman function are provided on the Microsoft Office website.
If you get an error from the Excel Roman function this is likely to be the #VALUE! function: