# 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.

## Usage

Use the `ARABIC` formula with the syntax shown below, it has 1 required parameter:

Parameters:
1. 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 the `ARABIC` 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., "XII-XXV-MMXIX" 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.

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.

You can learn more about the `ARABIC` Google Sheets function on Google Support.