Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > ROMAN
 

ROMAN(number [,form])

 
 Converts an arabic numeral to roman, as text.

 numberThe number you want to convert.
 formThe number specifying the type of roman numeral you want:
0 = Classic
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.

     EXAMPLES
     
     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!
    		 
     Functions - R | Index - R | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top