ROMAN()
Syntax. ROMAN(number,form)
Definition. This function converts an Arabic number into a Roman numeral.
Arguments
number (required) The Arabic number you want to convert. You can specify numbers between 0 and 3999. For negative values and numbers greater than 3999, the
#VALUE!
error is returned.form (optional) A number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases (see Figure 16-23). The possible values of form are shown in Table 16-4.
Table 16-4. Possible Values for the form Argument
Value | Type of Roman Numeral |
---|---|
0 | Classic |
1 | More concise |
2 | More concise |
3 | More concise |
4 | Simplified |
TRUE | Classic |
FALSE | Simplified |
Figure 16-23. The different styles ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.