ROMAN (Roman numeral)

<< Click to Display Table of Contents >>

ROMAN (Roman numeral)

Syntax:

ROMAN(Number [, Format])

Description:

Converts an Arabic numeral into a Roman numeral (as a text string).

Number must be ≥ 0 and < 4000.

Number should be an integer, digits right of the decimal point are ignored.

If Number equals zero, an empty text string will be returned.

If the optional argument Format is used, PlanMaker tries to create a shorter form of the Roman numeral. Format can be any integer from 0 (do not shorten) through 4 (shorten as much as possible).

Example:

ROMAN(1999) returns MCMXCIX

ROMAN(1999, 0) returns MCMXCIX as well

ROMAN(1999, 1) returns MLMIL

ROMAN(1999, 2) returns MXMIX

ROMAN(1999, 3) returns MVMIV

ROMAN(1999, 4) returns MIM