Microsoft Office Tutorials and References
In Depth Information
l The Function Arguments
dialog box appears.
Click in the cell(s) or
type the values
requested in each field.
l For this example, click in
the cell containing the
value you entered in
l Type the number of
decimal places to which
you want to round. A
negative number refers
to decimal places to the
left of the decimal point.
l The result appears in the cell.
Did You Know?
If you do not know which function you want to
use, type a question in the Search for a Function
field in the Insert Function dialog box. For help with
the function itself, click Help on This Function in the
Function Arguments dialog box.
Do not confuse the ROUND function with number
formatting. ROUND works by evaluating a number in an
argument and rounding it to the number of digits you
specify in the second field of the Function Arguments
dialog box. When you format numbers, you simplify the
appearance of the number in the worksheet, making
the number easier to read. The underlying number is
Chapter 2: Work with Formulas and Functions