Microsoft Office Tutorials and References

In Depth Information

l
The Function Arguments

dialog box appears.

6

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

Step 1.

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.

7

7

Click OK.

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.

Caution!

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

not changed.

Chapter 2: Work with Formulas and Functions

33