ARABIC

ARABIC - This function calculates the value of a Roman number.

Syntax:

ARABIC(text)

text - represents the text for the roman number. The value must be between 0 and 3999.

Example:

Ever see those Roman numbers at the end of T.V. shows. Well now you can put them into a spreadsheet and see what number they represent.

=ARABIC("MMVIII") will return 2008
=ARABIC("MCMLXX") will return 1970 (year I was born)

Note: The Roman numeral must be in "".

Screen Shot: