WorksheetFunction.Roman Method
| Excel Developer Reference |
Converts an arabic numeral to roman, as text.
Syntax
expression.Roman(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Double | Number - the Arabic numeral you want converted. |
| Arg2 | Optional | Variant | Form - a number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases. |
Return Value
String
Remarks
| Form | Type |
|---|---|
| 0 or omitted | Classic. |
| 1 | More concise. See example below. |
| 2 | More concise. See example below. |
| 3 | More concise. See example below. |
| 4 | Simplified. |
| TRUE | Classic. |
| FALSE | Simplified. |
- If number is negative, the #VALUE! error value is returned.
- If number is greater than 3999, the #VALUE! error value is returned.
See Also