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)