ID EN
…
#Math

ROMAN

Excel Functions

Converts numbers to Roman numerals

Syntax

EXCEL 
=ROMAN(number, [form])

Arguments

Parameter Description
number Number (in Arabic numeral) you want to convert to Roman numeral.
form [optional] The type of Roman numeral you want.

Return Value

A Roman numeral in text

Details

The ROMAN function converts a number to a Roman numeral. For example: ROMAN takes two arguments: number and form. Number should be a whole number between 1 and 3999. The form argument controls the convention used for Roman numbers. The argument is optional and the default is zero (0), which results in classic non-abbreviated Roman numbers. Other possible values are 1-4, which specify progressively more concise output. For example: See more form samples below. The table below lists available Roman numbers with their equivalent Arabic number value. The ROMAN function converts Arabic numbers to Roman numbers. Use the ARABIC function to convert Roman numbers to Arabic numbers.

Examples

Example 1

The ROMAN function converts a number to a Roman numeral. For example:

EXCEL 
=ROMAN(4) // returns "IV"
=ROMAN(9) // returns "IX"
=ROMAN(99) // returns "XCIX"
=ROMAN(100) // returns "C"
Example 2

ROMAN takes two arguments: number and form. Number should be a whole number between 1 and 3999. The form argument controls the convention used for Rom

EXCEL 
=ROMAN(1999,0) // returns "MCMXCIX"
=ROMAN(1999,2) // returns "MXMIX"
=ROMAN(1999,4) // returns "MIM"

See Also

ARABIC