ARABIC converts a Roman numeral written as text into its numeric value. It is the reverse of the ROMAN function and works on values from 1 to 3999.
=ARABIC(text)What does ARABIC do?
ARABIC is a Math and Trigonometry function that reads a Roman numeral such as XIV and returns the number it represents, in this case 14. It is the mirror image of the ROMAN function, which turns numbers into Roman numerals. The function accepts text, so the Roman numeral can come from a cell, a label, or a text string.
Roman numerals still appear in real work: chapter and section numbers in reports, edition numbers on products, copyright years on templates, and legacy identifiers in databases. When those values arrive as text, you cannot sum, sort, or compare them as numbers. ARABIC solves that by converting them in one step, so you can use the results in calculations, lookups, and charts.
A typical situation is a product catalogue where the edition is stored as IV or XII. A colleague needs total sales by edition, but the edition column is text. With ARABIC you can build a helper column that holds the numeric edition, then sort, filter, or sum normally. The function is also useful when cleaning imported data that mixes Roman and Arabic numerals in the same column.
When to use ARABIC
- Converting edition numbers such as
IIorXIVinto numbers for sorting and filtering. - Turning chapter or section labels like
Chapter IVinto numeric values for reports. - Cleaning imported data where some rows store numbers as Roman numerals.
- Building a lookup key when one table uses Roman numerals and another uses numbers.
- Validating user input that is supposed to be a Roman numeral between I and MMMCMXCIX.
ARABIC syntax
=ARABIC(text)| Argument | Required? | What to enter |
|---|---|---|
text | Required | The Roman numeral to convert, entered as text or as a reference to a cell containing text. It can be up to 255 characters, must be a valid Roman numeral, and represents a value from 1 to 3999. Example: =ARABIC("XIV") returns 14. |
What it returns: A whole number from 1 to 3999 that is the numeric value of the Roman numeral supplied. If the text is empty, ARABIC returns 0. If the text is not a valid Roman numeral, it returns the #VALUE! error.
ARABIC examples
1 Convert a single Roman numeral
The goal is to see how ARABIC reads a classic Roman numeral. The formula =ARABIC(B2) takes the text in cell B2, which is XIV, and evaluates it from left to right. X is 10, I before V means subtract 1, and V is 5, so the result is 14. The function returns the number 14, which can then be used in any calculation.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Label | Roman | |||
| 2 | Example | XIV | 14 | ||
| 3 | Note | Classic numeral | |||
| 4 |
2 Convert several numerals in a list
Here a list of Roman numerals needs numeric equivalents. The formula =ARABIC(B2) converts the first one, and filling it down converts the rest. IX becomes 9, XL becomes 40, and MCMXC becomes 1990. The result is a column of numbers you can sort or sum, which is not possible with the original text values.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Roman | |||
| 2 | First | IX | 9 | ||
| 3 | Second | XL | |||
| 4 | Third | MCMXC | |||
| 5 | Fourth | MMXXIV | |||
| 6 |
3 Extract the numeral from a label and convert it
Roman numerals often sit inside a label such as Chapter IV. The formula =ARABIC(RIGHT(B2, LEN(B2)-FIND(" ", B2))) first finds the space in the label, then takes everything after it with RIGHT and LEN. That extracted text, IV, is passed to ARABIC, which returns 4. The same pattern works for labels like Part XII or Section IX as long as there is one space before the numeral.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Section | Label | |||
| 2 | Intro | Chapter IV | 4 | ||
| 3 | Methods | Chapter XII | |||
| 4 | Results | Chapter IX | |||
| 5 |
4 Total sales by edition using a helper column
A product catalogue stores the edition as a Roman numeral, but the sales team needs total sales per edition. In cell C2 the formula =ARABIC(B2) converts the edition to a number, and it is filled down the column. A SUMIF on the helper column can then total sales for edition 4, edition 12, and so on. Without the helper column, the edition values would be text and could not be compared numerically.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Product | Edition | Sales | |||
| 2 | Widget | IV | 1200 | 4 | ||
| 3 | Gadget | XII | 850 | |||
| 4 | Widget | IV | 300 | |||
| 5 | Gizmo | IX | 640 | |||
| 6 |
5 Validate and convert a user-entered numeral
A form collects a Roman numeral and you want to confirm it is valid before using it. The formula =IFERROR(ARABIC(B2), "Invalid") tries the conversion and returns the number if it succeeds. If the text is not a valid Roman numeral, ARABIC returns #VALUE! and IFERROR replaces it with the word Invalid. This gives a clean validation step without a separate check.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Entry | Input | |||
| 2 | Valid | XIV | 14 | ||
| 3 | Invalid | IC | |||
| 4 | Valid | MMXXIV | |||
| 5 |
Common ARABIC errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The text is not a valid Roman numeral, for example IC, ABC, or a numeral with an invalid subtractive pair. | Check the spelling and the rules of Roman numerals. Wrap the formula in IFERROR to show a friendly message instead of the error. |
| #VALUE! | The argument is a number rather than text, such as =ARABIC(14). | Pass the numeral as text, for example =ARABIC("XIV"), or convert the cell value to text first. |
| #NAME? | The function name is misspelled, for example =ARABIK(B2), or the workbook uses a version of Excel that does not include ARABIC. | Spell the function as ARABIC. If the error persists, check that your Excel version supports it (Excel 2013 and later, and Microsoft 365). |
| 0 | The referenced cell is empty or contains an empty string. | ARABIC returns 0 for empty text. Use IF(B2="", "", ARABIC(B2)) if you want a blank result instead. |
Tips for using ARABIC
- ARABIC only handles values from 1 to 3999, which is the full range of standard Roman numerals.
- The function is not case-sensitive, so
xivandXIVboth return 14. - Use a helper column with ARABIC when you need to sort or filter by a Roman numeral, then hide the helper column if needed.
- Combine ARABIC with text functions such as
RIGHT,MID, orFINDto pull numerals out of labels likeChapter IV. - Wrap ARABIC in
IFERRORwhen the input comes from users or imports, so invalid entries do not break your report. - Remember that ARABIC is the inverse of
ROMAN;=ARABIC(ROMAN(2024))returns 2024.
Frequently asked questions
What does the ARABIC function do in Excel?
It converts a Roman numeral written as text into its numeric value. For example, =ARABIC("XIV") returns 14.
Why does ARABIC return #VALUE!?
The text is not a valid Roman numeral, or the argument is a number instead of text. Check the numeral and pass it as text, or use IFERROR to handle invalid entries.
Can ARABIC convert numbers back to Roman numerals?
No. ARABIC goes from Roman numeral to number. Use the ROMAN function for the reverse direction.
What is the largest number ARABIC can handle?
3999, written as MMMCMXCIX. Standard Roman numerals do not go above that value.
Is ARABIC available in all Excel versions?
It is available in Excel 2013 and later, Excel for Microsoft 365, Excel for the web, and Excel for Mac 2011 and later. Very old versions do not include it.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ARABIC reference