ARABIC Function in Excel – Convert Roman numeral into Arabic

ARABIC Function in Excel converts a Roman numeral into an Arabic numeral.

Syntax of ARABIC Function in Excel

ARABIC(text)

Where the text argument is a text representation of a Roman numeral

 

Example of ARABIC Function in Excel

Formula

ARABIC Function in Excel 1

  • In First 3 rows the Roman Arguments are passed as cell reference
  • In Last row Roman Arguments are passed directly

Note: If Roman Argument is passed directly to the function, then it must be encased within quotation marks

Result

ARABIC Function in Excel 2

#VALUE! Error occurs if the supplied text argument is not a valid Roman numeral.

previous ARABIC Function in Excel                                                                                                           next ARABIC Function in Excel