Microsoft Office Tutorials and References

In Depth Information

**BUILT-IN FUNCTIONS**

AVERAGE, ROUND, and ROUNDUP Functions

The AVERAGE function computes the average of a set of values. Figure E-21 shows the use of the AVERAGE

function in cell C17:

FIGURE E-21

AVERAGE function in cell C17

Notice that the value shown is a real number with many digits. What if you wanted to have the value

rounded to a certain number of digits? Of course, you could format the output cell, but doing that only

changes what is shown on the screen. You want the cell

s contents actually to be the rounded number.

Therefore, you need to use the ROUND function. Its syntax is:

’

ROUND(number, number of digits)

Figure E-22 shows the rounded average time (with two decimal places) in cell G17.

FIGURE E-22

ROUND function used in cell G17