The Excel ARABIC Function

Basic Description

The Excel Arabic function converts a Roman numeral into an Arabic numeral.

The syntax of the function is:

ARABIC( text )

Where the text argument is a text representation of a Roman numeral (no more than 255 characters long).

Note that:


Excel Arabic Function Examples

The spreadsheet below shows five examples of the Excel Arabic Function.

 Formulas:
 AB
1=ARABIC("IV")
2=ARABIC("-IV")
3=ARABIC("MCXX")
4MMXV=ARABIC(A4)
5=ARABIC("")
 Results:
 AB
14
2-4
31120
42015
50

For further details and examples of the Excel Arabic function, see the Microsoft Office website.


Arabic Function Errors

If you get an error from the Excel Arabic function, this is likely to be one of the following:

Common Errors
#VALUE!-Occurs if the supplied text argument is not a valid Roman numeral.
#NAME?-

Occurs if either:

  • The text argument is supplied directly to the function, but is not encased in quotation marks.
or
  • You are using an older version of Excel (pre-2013), that does not support the Arabic function.