ARABIC

Formulas / ARABIC
Convert Roman numerals to Arabic numerals.
==ARABIC(text)
  • text - a string that should be in quotation marks, empty string ("") or cell referencing text

Examples

  • =ARABIC("LVII")

    This function takes the Roman numeral "LVII" and converts it to"57", an Arabic number.


Summary

The ARABIC function is a useful tool for converting Roman numerals to their numeric equivalent. It takes one argument, Roman_text, which is a string with a Roman number, and returns the numeric value.

  • The ARABIC function takes one argument, a Roman number string, and returns a number in Arabic numeral form.
  • The string must be 255 characters or fewer and can be either upper or lower case.

Frequently Asked Questions

What is the ARABIC function?
The ARABIC function is used to convert Roman numerals to Arabic numerals.
What is the syntax for the ARABIC function?
The syntax for the ARABIC function is ARABIC( text ).
What is the argument for the ARABIC function?
The argument for the ARABIC function is text.
Is the text argument required?
Yes, the text argument is required.
What kind of text can be used as the argument for the ARABIC function?
The text argument is a string enclosed in quotation marks, an empty string (""), or a cell reference to a cell with text.
What does the ARABIC function return if Text is an invalid Roman numeral value?
The ARABIC function returns #VALUE! if Text is an invalid Roman numeral value.
What does the ARABIC function throw an error for?
The ARABIC function throws a #VALUE! error when the argument is a number, date, or text that is not a Roman numeral.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV