To understand the uses of this function, let’s consider a few examples:
If we provide the string as IV, the ARABIC function will return the value 4. The formula to be used is =ARABIC(“IV”).
Similarly, below are a few more examples:
We can also provide a reference to the cell containing the string. For example, as shown below, we provided a cell reference:
As seen above:
An empty string returns 0.
The space before and after the string is ignored.
When giving a cell reference, we do not need to use quotation marks.
Things to remember about the ARABIC Function
#VALUE! error – Occurs when the given value is an invalid value. So, this error will occur when the numbers, dates, and text are not valid Roman numerals.
#NAME? error – Occurs when we provide the string without “”.
When we use an empty string as an input value in this function, that is (“”), then Excel returns 0 for it.
The function accepts 255 characters, which is the maximum length of the argument. So, the largest number that can be returned is 255,000.
It is indifferent to the case of the text. So, a text entered in UPPER case of the text argument will give the same result as the text entered in lowercase. For example, MXMV will return the same result as mxmv – 1995.
The function ignores leading and trailing spaces. For example, =ARABIC(” MXMV”) will give same result as =ARABIC(“MXMV”).
It supports the evaluation of a negative Roman numeral, even though a negative Roman number is non-standard. For this, we need to insert a negative sign before the Roman text. For example, =ARABIC(“-MXMV”) = -1995.
The ARABIC function is the opposite of the ROMAN Function.
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.