Converts the specified Arabic numeral to its Roman equivalent.
Syntax
 Copy Code
|
|---|
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
Copy Code
|
|---|
=ROMAN(499) |
See Also
Function Reference
ARABIC Function