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 = Classic (default)
1 = More concise
2 = More concise
3 = More concise
4 = Simplified
True = Classic
False = Most 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.office.com

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


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