<< Click to Display Table of Contents >> ROMAN (Roman numeral)

Syntax:

ROMAN(Number [, Format])

Description:

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

Number must be ≥ 0 and < 4000.

Number should be an integer. If this is not the case, PlanMaker automatically removes all decimal places and converts the remaining number into a Roman numeral.

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) to 4 (shorten as much as possible).

Example:

ROMAN(1999) returns MCMXCIX

ROMAN(1999, 0) also returns MCMXCIX

ROMAN(1999, 1) returns MLMIL

ROMAN(1999, 2) returns MXMIX

ROMAN(1999, 3) returns MVMIV

ROMAN(1999, 4) returns MIM