Using the Excel ARABIC Function
Summary
The Excel ARABIC function converts a Roman numeral to an Arabic number. If you need to convert Arabic numbers to Roman numerals this is done using the ROMAN function.Syntax
=ARABIC (text)Syntax Breakdown
textThe text argument is required and is a string, enclosed in quotation marks ("), or a reference to a cell containing text. Text can accept entries up to 255 characters. The case of the text does not impact the output. For example, =ARABIC("MM") and =ARABIC("mm") will both return 2,000.
Usage Notes
The ARABIC function is able to convert a Roman numeral into Arabic numbers.Roman Numeral Review
The following chart provides a brief overview of Roman numerals and their Arabic equivalent.
ARABIC Errors
If the text argument is not valid the #VALUE! error is returned. Examples of invalid text include dates, numbers, and text that is not a valid Roman numeral. Empty strings("") do not return an error. Rather, the return zero (0).
