Documentation/How Tos/Calc: ROMAN function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 08:27, 31 December 2007 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


ROMAN

Returns a Roman numeral (eg XIV), as text, given a number.

Syntax:

ROMAN(number; mode)

number is a number in the range 1-3999 that is to be converted into a Roman numeral.
mode (optional, in the range 0-4) indicates the degree of simplification. The higher the value, the greater is the simplification of the Roman number.

Example:

ROMAN(999)

returns CMXCIX.

ROMAN(999; 0)

returns CMXCIX.

ROMAN(999; 1)

returns LMVLIV.

ROMAN(999; 2)

returns XMIX.

ROMAN(999; 3)

returns VMIV.

ROMAN(999; 4)

returns IM.

See also:

ARABIC

Text functions

Issues:

ROMAN is not included in the forthcoming ODFF international standard, and should not be regarded as portable.

Personal tools