This function converts the specified Roman value to an Arabic value.

Syntax

ARABIC(text)

Arguments

For the argument, a string enclosed in quotation marks or a reference to the cell (posessing text value only) can be specified.

Remarks

In this function, specifying the text in lower case or upper case doesn't matter because the case of the argument (supplied as a text value) is ignored.

Data Types

Accepts string data. Returns numeric data.

Examples

ARABIC("XIXI") gives the result 20

ARABIC("LIV") gives the result 54

ARABIC(C2) gives the result 61 where C2 is a cell reference containing the text value LXI.