ARABIC
TheARABIC
function returns the Arabic numeral (as a number) corresponding to a given Roman numeral. This function is useful for converting Roman numerals to Arabic numerals, which is helpful in various calculations and data analysis tasks.
 How to use
ARABIC
formula?  Examples of using
ARABIC
formula ARABIC
formula not working? Similar formulas to
ARABIC
Usage
Use the ARABIC
formula with the syntax shown below, it has 1 required parameter:
 roman_numeral (required):
The Roman numeral to be converted to an Arabic numeral. This parameter must be a valid Roman numeral (I, V, X, L, C, D, or M) with a value between 1 and 3999.
Examples
Here are a few example use cases that explain how to use theARABIC
formula in Google Sheets.
Converting Roman numerals to Arabic numerals
The most common use case for the ARABIC
function is to convert Roman numerals to Arabic numerals. For example, you might have a list of Roman numerals representing sales figures and need to sum them up to get the total sales amount in Arabic numerals.
Validating Roman numerals
You can also use the ARABIC
function to validate whether a given string is a valid Roman numeral. If the function returns an error, the input is not a valid Roman numeral.
Converting Roman numeral dates to regular dates
Sometimes, you might encounter dates in Roman numeral format (e.g., "XIIXXVMMXIX" for December 25th, 2019) and need to convert them to regular date format. The ARABIC
function can be used to extract the month, day, and year components from the Roman numeral date.
Common Mistakes
ARABIC
not working? Here are some common mistakes people make when using the ARABIC
Google Sheets Formula:
Using an invalid Roman numeral
If you pass an invalid Roman numeral to the ARABIC
function, it will return an error. Check that the numeral is valid and contains only the characters 'I', 'V', 'X', 'L', 'C', 'D', and 'M'.
Using a Roman numeral that is too long or too short
The ARABIC
function can only convert Roman numerals between 1 and 10 characters in length, inclusive. If you pass a numeral that is shorter or longer than this, the function will return an error.
Related Formulas
The following functions are similar to ARABIC
or are often used with it in a formula:

ROMAN
The
ROMAN
formula converts a number to a Roman numeral. The function takes a number and an optional rule_relaxation parameter that specifies how strict the function should be when converting the number to Roman numerals. The function is commonly used in historical, educational, and religious contexts. 
ARABIC
The
ARABIC
function returns the Arabic numeral (as a number) corresponding to a given Roman numeral. This function is useful for converting Roman numerals to Arabic numerals, which is helpful in various calculations and data analysis tasks. 
CONVERT
The
CONVERT
formula is used to convert a value from one unit of measurement to another. This formula is most commonly used to convert metric units to imperial units or vice versa. 
SUMIF
The
SUMIF
formula is used to add up values in a range that meet a specific criterion. It can be used to sum values based on text, numbers, or dates. The formula is most commonly used in financial analysis, budgeting, and data analysis. 
SUMIFS
The
SUMIFS
formula is a function in Google Sheets that adds the values in a specified range based on multiple criteria. It is most commonly used to sum data that meets specific criteria, such as summing sales for a particular month by region or summing expenses for a specific category and date range.
Learn More
You can learn more about the ARABIC
Google Sheets function on Google Support.