ID EN
…
#Math

ARABIC

Excel Functions

Converts a Roman numerals to an Arabic numerals

Syntax

EXCEL 
=ARABIC(roman_text)

Arguments

Parameter Description
roman_text The Roman numeral in text that you want to convert.

Return Value

A number (in Arabic numeral)

Details

The ARABIC function converts a Roman numeral to a number in Arabic numeral form. The result from ARABIC is a numeric value. ARABIC takes just one argument, roman_text, which should be a Roman number provided as a text string. For example, the formula below converts "VII" to the number 7: The ROMAN function performs the opposite conversion: The table below lists available Roman numbers with their equivalent Arabic number value.

Examples

Example 1

ARABIC takes just one argument, roman_text, which should be a Roman number provided as a text string. For example, the formula below converts "VII" to

EXCEL 
=ARABIC("VII") // returns 7
Other examples
EXCEL 
=ARABIC("L") // returns 50
 =ARABIC("C") // returns 100
 =ARABIC("M") // returns 1000
 =ARABIC("MM")+1 // returns 2001
Other examples

The ROMAN function performs the opposite conversion:

EXCEL 
=ROMAN(2021) // returns "MMXXI"
=ARABIC("MMXXI") // returns 2021

See Also

ROMAN