Microsoft Office Tutorials and References
In Depth Information
The ROMAN function converts an Arabic numeral to Roman, as text.
The NUMBER argument is the Arabic numeral you want converted and the FORM argument is a
number specifying the type of Roman numeral you want. If number is negative or greater
than 3,999, an error value is returned. The Roman numeral style ranges from Classic to
Simplified (0 to 4), becoming more concise as the value of form increases. You can see an
example of the result of the formula =ROMAN(999,n) in the table shown in Figure 10.21.
Use the ROMAN
function to convert Arabic
numerals to Roman.
The ROUND function rounds a number to a specified number of digits.
If digits is greater than 0 (zero), then number is rounded to the specified number of decimal
places. If digits is 0, then number is rounded to the nearest integer. If digits is less than 0,
then number is rounded to the left of the decimal point. For example: ROUND(9.95, 1) equals
10.0 and ROUND(5025,–2) results in 5000.
The NUMBER argument is the number you want to round.
The DIGITS argument specifies the number of digits to which you
want to round the number.