ROMAN

Formats a number in Roman numerals.

Sample Usage

ROMAN(499,0)

ROMAN(A2)

Syntax

ROMAN(number, [rule_relaxation])

• number - The number to format, between 1 and 3999, inclusive.

• rule_relaxation - [ OPTIONAL - 0 by default ] - The degree to which traditional syntax rules may be relaxed, between0 and 4 inclusive.

  • 0 indicates strict precedence rules, where I may only precede V and X, V may only precede X, X may only precede Land C, L may only precede C, and C may only precede D and M. Therefore ROMAN(499,0) is CDXCIX.

  • 1 indicates a relaxation where V may precede L and C and L may precede D and M. Therefore ROMAN(499,1) isLDVLIV.

  • 2 indicates a further relaxation where I may precede L and C, and X may precede D and M. ThereforeROMAN(499,2) is XDIX.

  • 3 indicates a further relaxation where V may precede D and M. Therefore ROMAN(499,3) is VDIV.

  • 4 indicates a further relaxation where I may precede D and M. Therefore ROMAN(499,4) is ID.

See Also

ARABIC: Computes the value of a Roman numeral.