Formulas and Functions

Chapter 8 Numeric Functions 191
Examples
=ROMAN(12) returns XII.
=ROMAN(999) returns CMXCIX.
=ROMAN(999, 1) returns LMVLIV.
=ROMAN(999, 2) returns XMIX.
=ROMAN(999, 3) returns VMIV.
Related Topics
For related functions and additional information, see:
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
ROUND
The ROUND function returns a number rounded to the specied number of places.
ROUND(num-to-round, digits)
 num-to-round: The number to be rounded. num-to-round is a number value.
 digits: The number of digits you want to retain, relative to the decimal point. digits
is a number value. A positive number represents digits (decimal places) to the right
of the decimal point to include. A negative number species digits to the left of the
decimal point to replace with zeros (the number of zeros at the end of the number).
Examples
=ROUND(1.49, 0) returns 1.
=ROUND(1.50, 0) returns 2.
=ROUND(1.23456, 3) returns 1.235.
=ROUND(1111.222, -2) returns 1100.
=ROUND(-2.2, 0) returns -2.
=ROUND(-2.8, 0) returns -3.
Related Topics
For related functions and additional information, see:
“CEILING” on page 170