Google Sheets-funktion

ARABIC

Converts a Roman numeral to an Arabic numeral.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

ARABIC(text)

The ARABIC function takes a text string representing a Roman numeral and converts it into its corresponding integer value. It is the inverse of the ROMAN function and supports values up to 255.

Argument

textobligatorisktA string enclosed in quotation marks, an empty string, or a reference to a cell containing a Roman numeral.

Exempel

=ARABIC("VII")

Resultat: 7

Converts the Roman numeral VII to the integer 7.

=ARABIC("MCMXC")

Resultat: 1990

Converts the Roman numeral MCMXC to the integer 1990.

Vanliga frågor

What happens if the Roman numeral is invalid?

The function will return a #VALUE! error if the input string is not a valid Roman numeral.

Relaterade funktioner

ROMAN