Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

ROMAN

Syntax: ROMAN(number, mode)

The ROMAN function converts an Arabic number into a Roman numeral string. As implemented in OpenOffice.org Calc, Roman numerals can only represent numbers from 0 to 3999; therefore, the number argument cannot be anything else but an integer from that range.

Here is an example of the use of the ROMAN function:

=ROMAN(2011)

returns MMXI.

Figure 9-6. Sample result of the ROMAN function

The second argument, mode, is an optional numerical value between 0 and 4. It specifies the degree of simplification of the resulting Roman numeral. Think of it as a way to shorten the resulting Roman numerals. Here is an example ...