引数
text必須
A string enclosed in quotation marks, an empty string, or a reference to a cell containing a Roman numeral.
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.
=ARABIC("VII")→7Converts the Roman numeral VII to the integer 7.
=ARABIC("MCMXC")→1990Converts the Roman numeral MCMXC to the integer 1990.
Select a cell
Click on the cell where you want to display the converted number.
Enter the formula
Type =ARABIC("text") replacing "text" with the Roman numeral string or cell reference.
Press Enter
Press the Enter key to calculate and display the result.
The function will return a #VALUE! error if the input string is not a valid Roman numeral.