ROMAN

Converts the specified Arabic numeral to its Roman equivalent.

Syntax

FUNC( Integer n ) → Text

Parameters

n

Required. The number to convert.

Remarks

If n is less than 0  or greater than or equal to 4000, the function returns the #NUM! error value. If n is 0, an empty string is returned.

The following table lists the values of the individual roman numerals. Roman numerals that precede (directly or indirectly) a larger-valued roman number subtract their value from the final value.

Roman numeral	Value
I	1
V	5
X	10
L	50
C	100
D	500
M	1000

Example

Formula

=ROMAN(499)

See Also

Function Reference
ARABIC Function