We all know that Excel provides various built-in functions and formulas for performing mathematical calculations. On that note, the ARABIC function is categorized as the Math function in Excel. The function converts a Roman numeral to an Arabic numeral. Usually, we use Roman numerals while creating a document for a project or ranking purposes or use them in books to number the chapters.
Today, we will see how to use the Excel ARABIC function with its syntax, description, and examples. Get an official version of MS Excel from the following link:
https://www.microsoft.com/en-in/microsoft-365/excel
Jump To
What is the ARABIC Function?
ARABIC is one of the built-in functions in Microsoft Excel. It comes under Math functions. We can use this function in our spreadsheet whenever we want to convert Roman numerals to Arabic numerals.
1) Syntax
- This is the basic syntax of the Excel ARABIC Function.
=ARABIC(roman_text)
2) Arguments
- roman_text – The input Roman numeral that you want to convert.
3) Motive
- This function will convert given Roman numerals to Arabic numerals.
4) Return Value
- It returns the corresponding number (Arabic numeral).
Note:
1) If you don’t give the valid input value, this function returns the #VALUE! Error.
2) If you use an empty string (“”) in the ARABIC function, it returns 0.
3) The maximum length of roman_text is 255 characters.
What Will ARABIC Function Do?
As we said earlier, the ARABIC function will convert the given Roman number which is in text format into its corresponding Arabic number. This function is categorized as “Math” in Excel. Let’s see an example scenario to make you understand it easily.
Here, we have given a few Roman numerals and their corresponding Arabic numerals.
| Roman Numerals | Arabic Numerals |
|---|---|
| I | 1 |
| II | 2 |
| III | 3 |
| IV | 4 |
| V | 5 |
| X | 10 |
| L | 50 |
| C | 100 |
| D | 500 |
| M | 1000 |
Step 1: For instance, we have plenty of sub-sections for the class 10th in a school. And we usually mention those sections with Roman numbers. Each Roman number indicates its respective Arabic number. We can get the Arabic numbers using this ARABIC function.
Step 2: To get those Arabic numbers, we need to apply the following formula in any cell where we want to get the result.
=ARABIC(B3)
Step 3: Now, click on the Enter button to get the result.
Step 4: To fill down the remaining cells, you just drag down the first cell. It will auto-fill the remaining cells as shown in the below screenshot.
We hope that the given scenario helped you to understand the ARABIC function. Move to the below section if you have any confusion related to the working nature of this function.
Alternate Example
Here we will see how to apply the ARABIC function in the spreadsheet with simple examples.
1) Suppose you want to get a single ARABIC number of a specific Roman letter in a cell, then you can directly apply it to the formula.
2) If we want to get the Arabic number of the Roman letter “VII“, we can apply the following formula in a cell where we want the result.
=ARABIC(“VII”)
3) Hit the Enter button to get the result, as shown in the below image.
4) By following the above example, we will apply the following formulas to get their Arabic numerals.
=ARABIC(“L”)
=ARABIC(“CM”)
=ARABIC(“M”)
=ARABIC(“MMC”)
5) Now, click on the Enter button after typing each formula in the spreadsheet to get the result as shown in the below image.
By doing so, you can quickly get the Arabic values of the given Roman numbers in the worksheet.
Use ARABIC Function with Empty String
- If you use an empty string (“”) in the ARABIC function, it returns 0.
Input that Causes #VALUE! Error
- If the input is not a valid value, this function returns the #VALUE! Error.
Citations
To understand the usage of the ARABIC function, we have referred to the following articles. They helped us to know the purpose of this function. You can also check them out using the links: ARABIC function[1], and What are ARABIC numerals?[2].
- https://bettersolutions.com/excel/functions/arabic-function.htm
- https://en.wikipedia.org/wiki/Arabic_numerals
Verdict
With the help of the given scenarios and examples, you can easily understand the purpose of the ARABIC function in Excel and how to apply it in the spreadsheet. The screenshots help to learn it even easier. Drop your feedback in the below comment section. Thanks for visiting AawExcel. Keep Learning!!
If you want to know what people think about this ARABIC Function of Excel, then we suggest you look for it on the Quora interaction webpage. From there you can get to know more about the Excel ARABIC function. Here, we have provided the link to Quora’s official website.
Video Tutorial
The following video will show you how to use the Excel ARABIC function in the spreadsheet with proper examples.
Read Ahead:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
