Excel - Microsoft Excel Roman Function

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 : 

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. 

Roman Function Error

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

Common Error