The ARABIC function converts a Roman numeral to an Arabic numeral.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

=ARABIC(text)

Arguments

Argument Description
text A string enclosed in quotation marks, an empty string (“”), or a reference to a cell containing text

Examples

  A B C D
1 Formula Formula Result Notes
2   =ARABIC(“LVII”) 57 Returns an Arabic number based on the Roman number LVII
3   =ARABIC(“-IV”) -4 Returns an Arabic number based on the Roman number -IV
4 MMXV =ARABIC(A4) 2015 Returns an Arabic number based on the Roman number MMXV located in cell A4

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied text argument is not a valid Roman numeral
#NAME? Occurs if a text argument, supplied directly to the function, is not encased in quotation marks