This function converts an arabic numeral to a roman numeral text equivalent.
ROMAN(number,style)
This function has these arguments:
| Argument | Description |
|---|---|
| number | Arabic number to convert |
| style | Type of roman numeral |
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.
Accepts numeric data. Returns string data.
ROMAN(100,3)