Function Reference: ARABIC ROMAN
| Syntax | ||
| =ARABIC(text) =ROMAN(number,[form]) |
||
| Purpose / Description | ||
| ARABIC returns a number derived from a test string containing a number represented as roman numerals. ROMAN returns a text string being a number represented in roman numerals. |
||
| Arguments | ||
| Name | Type | Description |
| text | text string | A reference or nested expression that returns a valid reference, a constant or a nested expression that returns a text string whose contents are to be interpreted as roman numerals and converted to a number. Since this function works with specific letters, any number sor logical values will not represent a valid roman number, so will return #VALUE!. |
| number | number | A reference or nested expression that returns a valid reference,to a range, a nested expression or constant number that provides the number whose value is to be represented using roman numerals in a text string. Text strings and logical values that can be coerced to numbers are acceptable. The value must be in the range 0 ≤ number < 4000. If the value passed is not an integer, it will be truncated to an integer value. |
| [form] | number or logical | An optional reference or nested expression that returns a valid reference, a constant or a nested expression that returns a formatting code. Unusually, logical values do not coerce, but are interpreted as shown below, with different values than would arise with coercion. If form is 0, TRUE or omitted, the classic form of roman numeral enumeration is used. This is the form most commonly used in contracts and other legal documents. If form is 1 a more concise form is used, broadly simplifying by 50s. If form is 2 a further more concise from is used, broadly grouping by 10s. If form is 3 a further more concise from is used, broadly grouping by 5s. If form is 4 or FALSE the simplified form is used, usually significantly reducing the number of letters required. |
| Return Values | ||
| Type | Specific Value | Description |
| number | ARABIC will return a number if the value of text can be interpreted as a roman number. | |
| text string | ROMAN will return a text string encoded as roman numerals if the value of number (truncated to integer) is between 0 and 3999 inclusively. If the value of number is 0, it returns an empty string since the romans lacked a representation for 0. | |
| error | #VALUE! | If text contains characters other than roman numerals. If number is less than 0 or greater than or equal to 4000. |
| error | Any errors referenced by arguments are returned due to propagation of error values.. | |
| Notes / Comments / Advice / Warnings | ||
| Comment: | Although ROMAN will only work with values in the range 0 ≤ number < 4000, ARABIC will interpret roman numerals representing values greater than 4000. However, the Romans used bars above their numbers for amounts above 5000. | |
| Comment: | The main use of these functions might be in converting between section numbers where an Excel document needs to create and display values that link to an associated legal document, perhaps generated in word.To use lower case representations as are commonly used in contracts and other legal documents, enclose the results of ROMAN in a LOWER function. | |
| Examples: | Open / download sample workbook: ARABIC, ROMAN.xlsx | |