Definition

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.

In order to use the ROMAN formula, begin typing the formula in the area you would like to display the outcome: 

 

 

 

 

 

The style of roman numeral is set by the numeric value of the style argument:

Style valueRoman numeral style
0 or omittedClassic
1More concise
2More concise
3More concise
4Simplified
TRUEClassic
FALSESimplified

An error is returned if the number argument is negative.

 

Error.

User does not have sufficient privileges to access this Content
Learn More