Microsoft Office Tutorials and References

In Depth Information

**ROMAN**

ROMAN

The
ROMAN
function converts an Arabic numeral to Roman, as text.

=ROMAN(number,form)

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.

Figure 10.21

Use the
ROMAN

function to convert Arabic

numerals to Roman.

ROUND

The
ROUND
function rounds a number to a specified number of digits.

=ROUND(number,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.

NUMBER

The
DIGITS
argument specifies the number of digits to which you

want to round the number.

DIGITS