- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - ARABIC Function
Description
The ARABIC function converts a Roman numeral to an Arabic numeral.
Syntax
ARABIC (text)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Text | A string enclosed in quotation marks, an empty string (""), or a reference to a cell containing text. | Required |
Notes
If an empty string ("") is used as an input value, 0 is returned.
The maximum length of the argument is 255 characters. Therefore, the largest number that can be returned is 255,000.
The case of the text argument is ignored. For example, "mxmvii" evaluates to the same result (1997) as "MXMVII."
Although a negative Roman number is non-standard, evaluation of a negative Roman numeral is supported. Insert the negative sign before the Roman text, such as "-MMXI."
Leading and trailing spaces are ignored.
If Text is not a valid value, ARABIC returns the #VALUE! error value.
Values that return a #VALUE! Error value include numbers, dates, and text that is not a valid Roman numeral.
If Text is not encased in quotation marks, ARABIC returns the #NAME? error value.
If ARABIC Function is not recognized (in case of versions previous to Excel 2013), the #NAME? error value is returned.
Applicability
Excel 2013, Excel 2016