ROMAN function

The ROMAN function in Excel converts an Arabic numeral (a standard number) into its Roman numeral equivalent as text.

Syntax

=ROMAN(number, [form])

Parameters

1. number (required): The Arabic numeral you want to convert. It must be a positive integer between 1 and 3999.
2. form (optional): Specifies the style of the Roman numeral. This is an integer between 0 and 4, with each value representing a different degree of simplification. If omitted, the default is 0 (classic style).

Style Options for form

Examples

1. Convert 2023 to Roman numerals (classic style):

   =ROMAN(2023)
   

   Result: MMXXIII

2. Convert 499 to a simplified Roman numeral:

   =ROMAN(499, 2)
   

   Result: XDIX

3. Convert 1 to Roman numerals (minimal style):

   =ROMAN(1, 4)
   

   Result: I

4. Convert a number in a cell (e.g., A1) to Roman numerals:

   =ROMAN(A1)
   

Notes

• If the number is less than 1 or greater than 3999, the function returns a #VALUE! error.
• Roman numerals are not case-sensitive, but Excel always returns them in uppercase.
• Simplified forms are non-standard but can be useful for certain applications or preferences.

This function is helpful for formatting, numbering chapters, or creating unique labels.