ARABIC

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

text
The 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.

Excel ARABIC Example

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).

Excel ARABIC VALUE Error