ROMAN

ROMAN(number [,form])

Returns the text string converting a binary number to a roman numeral.

 number The arabic number you want to convert. form (Optional) The number specifying the type of roman numeral you want:0 / True = Classic (default)1 = More concise2 = More concise3 = More concise4 = SimplifiedFalse = Really Simplified

 REMARKS
 * If "number" < 0, then ?? is returned.* If "number" > 3999, then #VALUE! is returned.* If "form" is left blank, then 0 is used.* There is a UDF function for this, include link.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =ROMAN(12) = XII 2 =ROMAN(12, 0) = XII 3 =ROMAN(12, TRUE) = XII 4 =ROMAN(12, 1) = XII 5 =ROMAN(12, FALSE) = XII 6 =ROMAN(499) = CDXCIX 7 =ROMAN(499, 0) = CDXCIX 8 =ROMAN(499, TRUE) = CDXCIX 9 =ROMAN(499, 1) = LDVLIV 10 =ROMAN(499, FALSE) = ID 11 =ROMAN(499, 2) = XDIX 12 =ROMAN(499, 3) = VDIV 13 =ROMAN(499, 4) = ID 14 =ROMAN(1234) = MCCXXXIV 15 =ROMAN(1993, 0) = MCMXCIII 16 =ROMAN(-10) = #VALUE! 17 =ROMAN("some text") = #VALUE!