# ROMAN function

Converts an arabic numeral to a roman numeral.

## Syntax

ROMAN(number,form)

Argument

Description

Remarks

number

The arabic numeral you want converted.

• If number is greater than 3999, the #VALUE! error value is returned.

• If this argument is negative, this function returns the #NUM! error value.

form

A number specifying the type of roman numeral you want.

• None.

## Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

 1 2 3 4 5 6 7
 A B Formula Description (Result) =ROMAN(499,0) Classic roman numeral style for 499 (CDXCIX) =ROMAN(499,1) More concise version for 499 (LDVLIV) =ROMAN(499,2) More concise version for 499 (XDIX) =ROMAN(499,3) More concise version for 499 (VDIV) =ROMAN(499,4) More concise version for 499 (ID) =ROMAN(2013,0) Classic roman numeral style for 2013 (MMXIII)
 Rate this content: