ROMAN

ROMAN(number [,form])

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

numberThe arabic number you want to convert.
form(Optional) The number specifying the type of roman numeral you want:
0 / True = Classic (default)
1 = More concise
2 = More concise
3 = More concise
4 = Simplified
False = 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!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top