Excel functions / Math
ARABIC function
Turns Roman numerals into a number.
Syntax
=ARABIC(text)
Arguments
text: Roman numerals, such as "MMXXIV". Capitals do not matter.
When to use it
ARABIC turns Roman numerals into an ordinary number, so they can be sorted or calculated with. It is the inverse of ROMAN.
Examples
A year in Roman numerals
A B C 1 Numerals 2 MCMXCIV 1994 In C2:
=ARABIC(A2)→ 1994Years since
A B C 1 Numerals 2 MCMXCIV 32 In C2:
=2026-ARABIC(A2)→ 32
Common mistakes
- Letters that are not numerals. Anything other than I, V, X, L, C, D and M gives #VALUE!.
ARABIC in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: ARABIC
- Danish: ARABISK
- Dutch: ARABISCH
- Finnish: ARABIA
- French: ARABE
- German: ARABISCH
- Hungarian: ARAB
- Italian: ARABO
- Norwegian: ARABISK
- Polish: ARABSKIE
- Portuguese (Brazil): ARÁBICO
- Portuguese (Portugal): ÁRABE
- Russian: АРАБСКОЕ
- Spanish: NUMERO.ARABE
- Swedish: ARABISKA
- Turkish: ARAPÇA