Skip to content
Google Sheets

ARABIC function in Google Sheets

Computes the value of a Roman numeral.

=ARABIC(roman_numeral)

ARABIC syntax and parameters

One argument, one required.

  • roman_numeralstringRequired

    The Roman numeral to format, whose value must be between 1 and 3999, inclusive.

ARABIC examples

Formulas you'll actually reuse.

  1. A Roman numeral back to a number:

    =ARABIC("MMXXVI")

    Result2026

  2. The next chapter number from a Roman-numbered heading:

    =ARABIC(A2) + 1

    Result13

ARABIC in Excel

Same name — your formula ports as-is.

Try ARABIC in the playground

Edit the example — nothing to install.

Preloaded with the ARABIC formula from Example 1 — change anything and watch it respond.

Loading the editor…

ARABIC errors

What they mean — and the fixes.

  • #VALUE!

    The text isn't a valid Roman numeral — only I, V, X, L, C, D, M are allowed.

Related functions

More ways Google Sheets gets this done.