This function converts an arabic numeral to a roman numeral text equivalent.
Syntax
ROMAN(number,style)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| number | Arabic number to convert |
| style | Type of roman numeral |
Remarks
The style of roman numeral is set by the numeric value of the style argument:
| Style value | Roman numeral style |
|---|---|
| 0 or omitted | Classic |
| 1 | More concise |
| 2 | More concise |
| 3 | More concise |
| 4 | Simplified |
| TRUE | Classic |
| FALSE | Simplified |
An error is returned if the number argument is negative.
Data Types
Accepts numeric data. Returns string data.
Examples
ROMAN(100,3)
Version Available
This function is available in product version 2.0 or later.
See Also
ABS | Math and Trigonometry Functions